PostgreSQL - 怎么将时间转换成秒

郑全

使用 extract(epoch from 搞定：

• select extract(epoch from(('2018-12-18 00:00:10'::timestamp - '2018-12-18 00:00:00')));
• select extract(epoch from(('2018-12-18 00:00:10' - '2018-12-18 00:00:00'::timestamp)));
• select extract(epoch from(('2018-12-18 00:00:10' - timestamp'2018-12-18 00:00:00')));
• select extract(epoch from((timestamp'2018-12-18 00:00:10' - '2018-12-18 00:00:00')));