SELECT CURRENT_TIMESTAMP;
SELECT TO_CHAR(CURRENT_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS');
SELECT EXTRACT(EPOCH FROM TIMESTAMP '2022-01-01 00:00:00');
SELECT TIMESTAMP 'epoch' + 1640995200 * INTERVAL '1 second';
SELECT EXTRACT(EPOCH FROM CURRENT_DATE);
SELECT EXTRACT(EPOCH FROM TIMESTAMP '2022-01-01');
亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>
推荐阅读:PostgreSQL中的时间戳函数有哪些