文章内容
2020/9/10 11:33:49,作 者: 黄兵
MySQL查询时间
在MySQL中如何查询时间,下面是一个示例:
SELECT * FROM events where event_date between '2018-01-01' and '2018-01-31'; -- Can include time by specifying in YYYY-MM-DD hh:mm:ss format: SELECT * FROM events WHERE event_date BETWEEN '2018-01-01 12:00:00' AND '2018-01-01 23:30:00';
获取当前时间的一些查询示例:
SELECT now(); -- date and time SELECT curdate(); --date SELECT curtime(); --time in 24-hour format
查找上周创建的行:
SELECT * FROM events WHERE event_date > date_sub(now(), interval 1 week);
要查找在一周前到现在三天之间安排的事件:
SELECT * FROM events WHERE event_date BETWEEN date_sub(now(), interval 1 week) AND date_add(now(), interval 3 day);
原文地址:
评论列表