markdown语法
708 2023-04-03 04:32:42
时间转时间戳
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');