Postgre时间戳与日期格式转换

SELECT EXTRACT(epoch FROM NOW());

SELECT EXTRACT(epoch FROM CAST('2022-10-11 11:21:00' AS TIMESTAMP));

SELECT EXTRACT(epoch FROM CAST('2022-10-11 11:21:00' AS TIMESTAMPTZ));

select  to_timestamp(1665458460)::date；

select  to_timestamp(1665458460)；

select  to_char(to_timestamp(1665458460), 'yyyy-mm-dd hh24:mi:ss')；

select  to_char(to_timestamp(1665458460), 'yyyy-mm-dd hh24:mi:ss.us')；