postgresql获取Unix时间戳

发布时间：2020-12-13 17:01:33 所属栏目：百科来源：网络整理

导读：-- timestamp to unix timestamp select now(),EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE 'now()')::int as ext,extract(epoch FROM now())::int,CURRENT_TIMESTAMP,date_part('epoch',CURRENT_TIMESTAMP)::int -- unix timestamp to timestamp SELECT T

-- timestamp to unix timestamp

select now(),EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE 'now()')::int as ext,extract(epoch FROM now())::int,CURRENT_TIMESTAMP,date_part('epoch',CURRENT_TIMESTAMP)::int

-- unix timestamp to timestamp

SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720.12 * INTERVAL '1 second';

--SELECT TIMESTAMP WITH TIME ZONE 'epoch' + extract(epoch FROM now())* INTERVAL '1 second';

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!