人大金仓时间转换

时间转时间戳

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');

 

 

时间查询后转时间戳

drop table IF exists tmp;
create table "tmp" ("name" varchar(765) NOT null,"v1" varchar(765) NOT NULL);

insert into "tmp"("name","v1") values('deltime','6');

-- 重点在查询这里，使用了字符串与月份相乘。

select floor(extract(epoch from ( now()-(select ("v1" * INTERVAL '1 month') from "tmp" where "name"='deltime')))) ,now()