First and last day of last month in Redshift

In Redshift, you can use date_trunc() (See online documentation).

For the first day of last month:

select date_trunc('month', current_date) - interval '1 month'

Or:

select date_add(month, -1, date_trunc('month', current_date))

For the last day of last month:

select date_trunc('month', current_date) - interval '1 day'

Or for last day in moth you can use a LAST_DAY Function. :) http://docs.aws.amazon.com/redshift/latest/dg/r_LAST_DAY.html

select last_day(current_date)

Related