试图在time1和time2之间计算mysql数据 [英] trying to count mysql data between time1 and time2

问题描述

我有一个数据库表'email_log'将填充以下信息：
用户，主题和打开（作为datetime）

我需要的是一个新的查询，从中可以看到有多少行包含 08:00 和 09:00 。

我没有工作：

  SELECT count（*）as count FROM email_log WHERE opened BETWEEN '00：08：00'AND'00：09：00'; 
  

有没有人知道这个伎俩？

解决方案

尝试这个

  SELECT COUNT（*）AS COUNT 
 FROM email_log 
 WHERE DATE_FORMAT（打开，％H：％i：％S）> '00：08：00'AND DATE_FORMAT（打开，％H：％i：％S）< '00：09：00'
  

I have a database table 'email_log' which would be filled with information as: user, subject and opened (as datetime)

What I need is a new query from which I can see how many rows contain the column 'opened' between 08:00 and 09:00.

What I had didn't work:

SELECT count(*) as count FROM email_log WHERE opened BETWEEN '00:08:00' AND '00:09:00';

Does anyone know the trick?

解决方案

Try this

SELECT COUNT(*) AS COUNT 
FROM email_log 
WHERE  DATE_FORMAT(opened,"%H:%i:%S")  > '00:08:00' AND  DATE_FORMAT(opened,"%H:%i:%S")  < '00:09:00' 

这篇关于试图在time1和time2之间计算mysql数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！