PostgreSQL sql语句:
SELECT EXTRACT(EPOCH FROM (TIMESTAMP '2020-11-18 16:39:54.981'- TIMESTAMP '2020-11-18 16:37:44.546'));
结果为:130.435s
Mysql sql语句:
SELECT TIMESTAMPDIFF(SECOND, '2024-05-09 17:50:45', '2024-05-09 17:51:16') AS seconds_difference;
结果为:31s