根据日期时间选择器中选择的特定日期，月份或年份从表中选择数据 [英] select data from table against particular day, month or year which is selected in datetimepicker

问题描述

我有一个带日期时间字段的表tblSale，用于存储每次销售的日期和时间，
用户可以通过从datetimepicker中选择日期来查看任何日期的销售额，

当我编写查询时，日期部分可以相同但时间不同.
第二件事是编写用户可以根据特定月份选择数据的查询，

I have a table tblSale with datetime field to store the date and time of every sale,,
user can check sales of any date, by selecting date from datetimepicker,

when i write query, date part can b same but time is different.
2nd thing is ho to write query that a user can select data according to particular month,,,

推荐答案

您可以使用DATEPART函数:

You can use the DATEPART function:

SELECT * FROM myTable WHERE DATEPART(year, @DATE)=DATEPART(year, dateField) AND DATEPART(month, @DATE)=DATEPART(month, dateField)

您可以使用

You can use DATEDIFF[^] in your WHERE clause.

To compare on the same day use

SELECT * FROM tblSale WHERE DATEDIFF(day,salesDate,@SELECTEDDATE)=0

要在同一个月进行比较，请使用

To compare on the same month use

SELECT * FROM tblSale WHERE DATEDIFF(month,salesDate,@SELECTEDDATE)=0

要在同一年进行比较，请使用

To compare on the same year use

SELECT * FROM tblSale WHERE DATEDIFF(year,salesDate,@SELECTEDDATE)=0

这篇关于根据日期时间选择器中选择的特定日期，月份或年份从表中选择数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！