如何在C Sharp中使用BETWEEN查询访问数据库 [英] how to use BETWEEN query for access database in c sharp

问题描述

我在项目中使用Access数据库.我需要在where子句中使用2个dates作为:SELECT * FROM date 1和date2之间的销售日期.

在date1和date2是datetime类型的日期的Access数据库中使用此查询的正确方法是什么.

I am using an Access database in my project. I need to use 2 dates ina where clause as: SELECT * FROM SALES WHERE DATE BETWEEN date1 AND date2.

What is the correct way to use this query in an Access database where date1 and date2 are dates of type datetime.

推荐答案

这可能有帮助:

This might help: 10 tips for working with dates in Microsoft Access[^].

Google is your friend.

这篇关于如何在C Sharp中使用BETWEEN查询访问数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！