mysql笔记
时间差函数(TIMESTAMPDIFF、DATEDIFF)
--0
select datediff(now(), now());
--2
select datediff('2015-04-22 23:59:00', '2015-04-20 00:00:00');
--2
select datediff('2015-04-22 00:00:00', '2015-04-20 23:59:00');
--1
select TIMESTAMPDIFF(DAY, '2015-04-20 23:59:00',
原创
2020-07-17 11:56:40 ·
326 阅读 ·
0 评论