两个时间戳之间的MYSQL查询 [英] MYSQL query between two timestamps

问题描述

我的数据库表中有以下条目

I have the following entry in my DB table

eventName(varchar 100) -> myEvent
date(timestamp) -> 2013-03-26 09:00:00

并且我正在尝试使用以下查询；

and I am trying to use the following query;

SELECT * 
FROM eventList 
WHERE `date` BETWEEN UNIX_TIMESTAMP(1364256001) AND UNIX_TIMESTAMP(1364342399)

即在2013-03-26 00:00:01和2013-03-26 23:59:59之间

i.e between 2013-03-26 00:00:01 and 2013-03-26 23:59:59

但这给了我0个结果.

我尝试过扩大日期范围，但没有运气，肯定在该范围内有结果.

I have tried expanding the date range with no luck and there are definitely results within the range.

感谢您的帮助.

推荐答案

尝试:

SELECT * 
FROM eventList 
WHERE  `date` BETWEEN FROM_UNIXTIME(1364256001) AND FROM_UNIXTIME(1364342399)

或

SELECT * 
FROM eventList WHERE  `date` 
BETWEEN '2013-03-26 00:00:01' AND '2013-03-26 23:59:59'

这篇关于两个时间戳之间的MYSQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！