CAST(EXTRACT(EPOCH
FROM CURRENT_TIMESTAMP )
* 1000 AS int8),to_char(to_timestamp(
CAST(EXTRACT(EPOCH
FROM CURRENT_TIMESTAMP )
* 1000 AS int8)
/ 1000) AT TIME ZONE
‘PRC‘,
‘yyyy-mm-dd hh24:mi:ss‘)
postgresql 13位时间戳
标签:sele zone post class extract rom postgre code har