如何找到两个日期之间的结果 [英] How to find Result between two dates

问题描述

我想通过选择两个日期来填充网格.
数据应在两个选定的日期之间.我不知道

@ date1和@ date2之间的CreatedDate

告诉我如何获取数据.

I want to fill grid by selecting two dates.
data should between two selected dates. i have little idea

WHERE CreatedDate between @date1 AND @date2

Tell me how can i get data.

推荐答案

请尝试使用此sql语句

Hi please try this sql statement

SELECT *
FROM TABLE 
WHERE CreateDate 
BETWEEN '01/01/2009' AND '01/31/2009'

投票是否有帮助....

Vote if it helps....

如果我正确理解了您的问题，那么您可以使用它来获取答案

if i understood your question correctly then you may use this to get the answer

DECLARE @date1 datetime,@date2 datetime
SET @date1='2012-07-20'
SET @date2='2012-07-25'
Select ColName from TableName WHERE ColName between @date1 AND @date2

您可以在文本框或其他任何位置提供@ date1和@ date2中的日期范围

you can give the date range in @date1 and in @ date2 from your textbox or anywhere else

我认为此代码可以为您

SELECT * FROM TABLE

之间的日期
Convert(varchar，CreatedOn，103)= CONVERT(varchar，ISNULL(``01/02/2012''，CreatedOn)，103)
AND Convert(varchar，CreatedOn，103)= CONVERT(varchar，ISNULL(''05/05/2012''，CreatedOn)，103)


"103"代表英式/法式



有关更多搜索，请访问此链接 http://www.sql-server-helper.com/tips/date -formats.aspx [^ ]

hi i Think This Code helps you

SELECT * FROM TABLE

WHERE DATE BETWEEN
Convert(varchar,CreatedOn,103)=CONVERT(varchar,ISNULL(''01/02/2012'',CreatedOn),103)
AND Convert(varchar,CreatedOn,103)=CONVERT(varchar,ISNULL(''05/05/2012'',CreatedOn),103)


"103" stands BRITISH/FRENCH FORMAT



for more search this link http://www.sql-server-helper.com/tips/date-formats.aspx[^]

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