时间转时间戳

SELECT EXTRACT(epoch FROM cast('2022-05-19 10:24:22'AS timestamp ) );
SELECT EXTRACT(epoch FROM now());

时间戳转时间

SELECT (to_timestamp(1652925867)+ INTERVAL '1 hour' *8);

select to_char(to_timestamp(_TIME) AT TIME ZONE 'UTC','YYYYMMDDHH24MISS');