We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
datediff
timediff
datediff()
语法 datediff(date1, date2) , date1 是起始时间, date2 是截止时间
datediff(date1, date2)
date1
date2
select datediff('2021-12-31', '2022-01-02'); // -2
如果时间不存在,返回 null
null
select datediff('2021-12-32', '2022-01-02'); // null
只有时间的日期部分是参与计算的。
select datediff('2021-12-31 23:59:59', '2022-01-02 00:00:00'); // -2
timediff()
语法 timediff(date-time1, date-time2) , date-time1 是开始时间, date-time2 是结束时间。
timediff(date-time1, date-time2)
date-time1
date-time2
select timediff('2022-01-01 00:00:00', '2022-01-02 00:00:00'); // -24:00:00
计算最大的时间差 838:59:59 , 35 天不到, 35 天是 840 小时。
838:59:59
35
840
select timediff('2021-11-10 00:00:00', '2022-01-02 00:00:00'); // -838:59:59
如果时间或者日期不存在,则返回 null
select timediff('2022-01-01 40:00:00', '2022-01-02 00:00:00'); // null select timediff('2022-01-41 00:00:00', '2022-01-02 00:00:00'); // null
如果不传时间,有个有意思的现象:
00:00:00
date-time1 > date-time2
00:00:01
date-time1 < date-time2
-00:00:01
select timediff('2022-01-31', '2022-01-02'); // 00:00:00 select timediff('2022-01-02', '2021-12-31'); // 00:00:01 select timediff('2021-12-31', '2022-01-02'); // -00:00:01
The text was updated successfully, but these errors were encountered:
No branches or pull requests
datediff()
计算两个日期之间的间隔差语法
datediff(date1, date2)
,date1
是起始时间,date2
是截止时间如果时间不存在,返回
null
只有时间的日期部分是参与计算的。
timediff()
计算两个时间之间间隔差语法
timediff(date-time1, date-time2)
,date-time1
是开始时间,date-time2
是结束时间。计算最大的时间差
838:59:59
,35
天不到,35
天是840
小时。如果时间或者日期不存在,则返回
null
如果不传时间,有个有意思的现象:
00:00:00
,date-time1 > date-time2
返回00:00:01
date-time1 < date-time2
返回-00:00:01
The text was updated successfully, but these errors were encountered: