pgsql里面的UNIX_TIMESTAMP 和 FROM_UN
2023-04-10 本文已影响0人
zxbyh
pgsql里面没有UNIX_TIMESTAMP 和 FROM_UNIXTIME, 因此可以直接定义
CREATE FUNCTION UNIX_TIMESTAMP() RETURNS integer AS $$
SELECT (date_part('epoch',now()))::integer;
$$ LANGUAGE SQL IMMUTABLE;
select UNIX_TIMESTAMP()
CREATE FUNCTION FROM_UNIXTIME(int) RETURNS timestamp AS $$
SELECT to_timestamp($1)::timestamp;
$$ LANGUAGE SQL IMMUTABLE;
select FROM_UNIXTIME(1681196150)
