在日期之间获取记录 [英] Get records between date
本文介绍了在日期之间获取记录的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
获取日期之间的记录,例如在mysql中
2009-08-11至当前日期
2009-08-11是检索所有日期,这只是一个例子
我试过过日期之间的时间(时间) )和DATE(时间)= CURDATE();
解决方案
http://msdn.microsoft.com/en-us/library/ms187922.aspx [ ^ ]
示例(D.)专门讨论日期,但你应该阅读所有...
尝试使用
set @ input_date = ' 2009-08-11 00:00:00';
SELECT *
FROM TableName
WHERE dateTimeColumnName BETWEEN DATE ( @input_date ) AND CURDATE();
Get records between date for example in mysql
2009-08-11 to current date
2009-08-11 is to retrieve all date , this is just an example
I have tried WHERE time between date(time) and DATE(time) = CURDATE();
解决方案
http://msdn.microsoft.com/en-us/library/ms187922.aspx[^]
Sample (D.) talks about dates specifically, but you should read all...
try with
set @input_date= '2009-08-11 00:00:00'; SELECT * FROM TableName WHERE dateTimeColumnName BETWEEN DATE(@input_date) AND CURDATE();
这篇关于在日期之间获取记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文