sql获取时间差

MySQL

SELECT TIMESTAMPDIFF(HOUR, '2023-10-01 12:00:00', '2023-10-02 15:30:00') AS hours_difference;

PostgreSQL

//EXTRACT(EPOCH FROM ('2023-10-02 15:30:00'::timestamp - '2023-10-01 12:00:00'::timestamp))
// 获取的是两个时间相差的秒数，在此基础上除3600获取相差的小时数，或者进行其他计算
SELECT EXTRACT(EPOCH FROM ('2023-10-02 15:30:00'::timestamp - '2023-10-01 12:00:00'::timestamp)) / 3600 AS hours_difference;

SQL Server

SELECT DATEDIFF(HOUR, '2023-10-01 12:00:00', '2023-10-02 15:30:00') AS hours_difference;

postgres sql 时间

----条件为时间的小时数除三余二
where cast(to_char("2024-10-22 13:00:00", 'HH24') as INTEGER) % 3 = 2