mysql:获取两个日期时间之间的记录计数 [英] mysql: get record count between two date-time
问题描述
我遇到了一个问题在MySQL。我想获取两个日期时间条目之间的记录计数。
例如:
在我的表中有一个名为created的列,其中包含 datetime
数据类型。
I am stuck with a problem in MySQL. I want to get the count of records between two date-time entries.
For example:
I have a column in my table named 'created' having the datetime
data type.
我要计算在今天上午4:30和当前日期之间创建日期 - 时间的记录TIME。
I want to count records which were created date-time between "TODAY'S 4:30 AM" and "CURRENT DATE TIME".
我尝试了一些MySQL的功能,但仍然没有运气。
I tried some of MySQL's functions but still no luck with it.
我这个?
感谢。
Can you please help me with this? thanks.
推荐答案
可能是:
SELECT count(*) FROM `table`
where
created_at>='2011-03-17 06:42:10' and created_at<='2011-03-17 06:42:50';
或在之间使用:
or use between
:
SELECT count(*) FROM `table`
where
created_at between '2011-03-17 06:42:10' and '2011-03-17 06:42:50';
您可以根据需要更改日期时间。可以使用 curdate()
或 now()
来获取所需的日期。
You can change the datetime as per your need. May be use curdate()
or now()
to get the desired dates.
这篇关于mysql:获取两个日期时间之间的记录计数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!