pgsql usage record
Format long type time field
-- long type time field formatted
SELECT
to_timestamp(create_time/1000) AT TIME ZONE 'Asia/Shanghai' AS create_time_local,
*
FROM Ftable_name;
-- long type time field formatted
SELECT
to_timestamp(create_time/1000) AT TIME ZONE 'Asia/Shanghai' AS create_time_local,
*
FROM Ftable_name;