过滤两个日期之间的数据 [英] Filter data between two dates

问题描述

亲爱的朋友们，我的数据库有一个字段日期时间，所有记录都与当前日期时间一起存储。虽然基于其他字段过滤数据没有问题，但我不知道如何在两个日期之间过滤数据。我正在使用存储过程，我想让用户输入两个日期来过滤其间的数据。除了直接回复之外，如果有人根据这些问题向我推荐一些文章/例子，我也将不胜感激。谢谢

Dear friends, My database has a field datetime and all records are being stored with current datetime. While I have no problem in filtering data based on other fields, I do not know how to filter data between two dates. I am using stored procedure and I want to give user to enter two dates for filtering data in between. Apart from direct reply, I would also be grateful if somebody refer me to some articles/examples based on such issues. Thank you

推荐答案

试试这些：



http://sqlmag.com/t-sql/datetime-calculations-part-1 [ ^ ]



http://stackoverflow.com/questions/16762554/compare-date-time-in -sql-server-t-sql [ ^ ]



http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5d04d343-8731- 4161-b9e3-1c0ccd93700c / date-comparison-in-stored-procedure [ ^ ]



希望它有所帮助，祝你好运。

Try these:

http://sqlmag.com/t-sql/datetime-calculations-part-1[^]

http://stackoverflow.com/questions/16762554/compare-date-time-in-sql-server-t-sql[^]

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5d04d343-8731-4161-b9e3-1c0ccd93700c/date-comparison-in-stored-procedure[^]

Hope it helps, good luck.

使用 BETWEEN（T-SQL） [ ^ ]声明;）

Use BETWEEN (T-SQL)[^] statement ;)

CREATE GetUserData
    @datefrom DATETIME
    @dateto DATETIME
AS
BEGIN
    SELECT *
    FROM TableName
    WHERE DateField BETWEEN @datedatefrom and @dateto
END

如何：使用ADO.NET和Visual C＃.NET调用参数化存储过程 [ ^ ]

配置参数和参数数据类型 [ ^ ]

这篇关于过滤两个日期之间的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！