# 上月同期
select now() + interval '-1 month';
select TO_CHAR(NOW() - INTERVAL '1 MONTH','YYYY-MM-DD') as "上月同期";
select TO_CHAR(NOW() - INTERVAL '1 MONTH','YYYY-MM-DD HH24:MI:SS') as "上月同期";
# 指定日期的上月同期 没有取上月最后一天
select date_trunc('day', date '2020-03-31') + interval '-1 month';
select to_char(date_trunc('day', date '2020-03-31') + interval '-1 month','yyyy-MM-DD'); # 2020-02-29
select TO_CHAR(date_trunc('day', date '2020-03-31') - INTERVAL '1 MONTH','YYYY-MM-DD HH24:MI:SS') as "上月同期";