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.

我想计算在TODAY'S 4:30 AM"和CURRENT DATE 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 07:42:50';

或使用 between:

SELECT count(*) FROM `table` 
where 
    created_at between '2011-03-17 06:42:10' and '2011-03-17 07: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屋！