Postgresql 获取当月天数
SELECT (dt - INTERVAL ‘0 day’) :: DATE as data
FROM generate_series(date_trunc(‘month’,now()), date_trunc(‘month’,now()) + interval’1 month - 1 day’, INTERVAL ‘1 day’) AS dt
Postgresql 获取当月天数
SELECT (dt - INTERVAL ‘0 day’) :: DATE as data
FROM generate_series(date_trunc(‘month’,now()), date_trunc(‘month’,now()) + interval’1 month - 1 day’, INTERVAL ‘1 day’) AS dt