1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
| SELECT timestampdiff(hour, '2023-03-10 10:35:10', '2023-03-10 09:10:05');
SELECT timestampdiff(hour, '2023-03-09 10:35:10', '2023-03-10 09:10:05');
SELECT timestampdiff(SQL_TSI_HOUR, '2023-03-09 10:35:10', '2023-03-10 09:10:05');
SELECT timestampdiff(minute ,'2023-03-10 10:35:10', '2023-01-10 09:10:05');
SELECT timestampdiff(hour, '2023-03-10 10:35:10', '09:10:05');
SELECT timestampdiff(hour, now(),now());
SELECT timestampdiff(hour, now(),utc_timestamp());
SELECT timestampdiff(hour, '2023-03-10 10:35:10', '');
SELECT timestampdiff(hour, '', '2023-03-10 10:35:10');
SELECT timestampdiff(hour, null, now());
SELECT timestampdiff(hour, now(), null);
|
