选择基于日期的记录,但我返回的日期不在范围内,有什么想法吗?
SELECT *
FROM TABLE
WHERE (
PAYMENT_DATE >= CONVERT(DATETIME, '2010-05-06')
AND PAYMENT_DATE <= CONVERT(DATETIME, '2013-11-11')
)例如,这将返回一个日期为"2008-04-10 00:00:00.000“的记录
发布于 2014-05-30 15:47:13
如果不使用参数,请始终使用不变的日期时间格式:
SELECT *
FROM [Table]
WHERE ([PaymentDate] >= '20100506' AND [PaymentDate] <= '20131111')发布于 2014-05-30 15:42:47
使用SQL between子句检查范围是很好的。
SELECT *
FROM table
WHERE PAYMENT_DATE BETWEEN CONVERT(datetime, '2010-05-06')
AND CONVERT(datetime, '2013-11-11')发布于 2014-05-30 15:38:12
试一试这个
这必须给出预期的结果
SELECT *
FROM table
WHERE (Convert(datetime,PAYMENT_DATE,103) >= CONVERT(datetime, '2010-05-06')
AND Convert(datetime,PAYMENT_DATE,103) <= CONVERT(datetime, '2013-11-11'))https://stackoverflow.com/questions/23949341
复制相似问题