Nólëbase

标签

开发/数据/数据库

计算机/数据库/postgres

计算机/数据库/postgresql

开发/语言/SQL

开发/数据/时间处理

开发/数据/数据处理

开发/数据/时区

字数

160 字

阅读时间

1 分钟

时间类型互相转换

sql

SELECT EXTRACT(EPOCH FROM CURRENT_TIMESTAMP::timestamp) AS unix_timestamp;

sql

SELECT EXTRACT(EPOCH FROM CURRENT_TIMESTAMP::timestamp) * 1000 AS unix_timestamp_milli;

sql

SELECT CEIL(EXTRACT(EPOCH FROM CURRENT_TIMESTAMP::timestamp)) AS unix_timestamp;

sql

SELECT CEIL(EXTRACT(EPOCH FROM CURRENT_TIMESTAMP::timestamp) * 1000)::bigint AS unix_timestamp_milli;

sql

SELECT TO_TIMESTAMP(EXTRACT(EPOCH FROM CURRENT_TIMESTAMP)) AS timestamp;

sql

SELECT DATE_TRUNC('second', TO_TIMESTAMP(EXTRACT(EPOCH FROM CURRENT_TIMESTAMP))) AS timestamp;

sql

SELECT CURRENT_TIMESTAMP::timestamp AT TIME ZONE 'UTC+08' AS now_china_timstamp

sql

SELECT CURRENT_TIMESTAMP::timestamp AT TIME ZONE 'Asia/Shanghai' AS now_china_timstamp

最后编辑于 4 个月前

查看完整历史