CODEWITHSUNDEEP
sqlamazon-redshift
Nithin Chandy
Nithin Chandy

Reputation: 707

First and last day of last month in Redshift

I want to find the first and last day of last month in Redshift. However, most of the postgresql features like date_trunc do not seem to work. How can I achieve that?

Upvotes: 16

Views: 57415

Answers (2)

Gordon Linoff
Gordon Linoff

Reputation: 1269873

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'

Upvotes: 45

Kirill Kuzikov
Kirill Kuzikov

Reputation: 101

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)

Upvotes: 10

Related Questions