gp查询上个月数据
SELECT *
FROM Conference
WHERE date_start >= date_trunc('month',current_date - interval '1' month)
and date_start < date_trunc('month',current_date)
查询这个月第一天
SELECT to_date(to_char(now(), 'yyyy-mm-01'),'yyyy-mm-dd')
gp查询上个月数据
SELECT *
FROM Conference
WHERE date_start >= date_trunc('month',current_date - interval '1' month)
and date_start < date_trunc('month',current_date)
查询这个月第一天
SELECT to_date(to_char(now(), 'yyyy-mm-01'),'yyyy-mm-dd')