PostgreSQLで1ヶ月分の日付を取得する

当日を含む過去１ヶ月の日付

SELECT
date
,to_char(cal.date, 'mm/dd(TMDy)') as 日付
FROM (
SELECT
GENERATE_SERIES::date as date
FROM
GENERATE_SERIES( (now() + '-1 MONTHS') , now() ,'1 DAYS')
) cal
ORDER BY
cal.date

　　　　　　⋮

今月の日付（１日から月末まで）

SELECT
date
,to_char(cal.date, 'mm/dd(TMDy)') as 日付
FROM (
SELECT
GENERATE_SERIES::date as date
FROM
GENERATE_SERIES( date_trunc('month',now()) ,date_trunc('month', now()) + '1 month' + '-1 days' ,'1 DAYS')
) cal
ORDER BY
cal.date

 

　　　　　　⋮