Get the last day of the month in Redshift
Redshift

Get the last day of the month in Redshift

How to use the last_day function in Redshift
Bartosz Mikulski
Bartosz Mikulski – 1 min read

Redshift gives us an easy way to get the date of the last day of a month. We no longer need to do date based calculations or tricks with date parsing. All we need is the last_day function.

The last_day function requires one parameter: a date or a timestamp. As the return value we will get the last day of the same month as the one given in the parameter. For example, if I pass 2020-12-18 to the function, I will get 2020-12-31:

select last_day(to_date('2020-12-18','YYYY-MM-DD'))
Older post

How to make an unconditional join in Redshift

LEFT OUTER JOIN ON 1=1 in Redshift

Newer post

How to purge a Kafka topic

How to remove all messages from a Kafka topic

Related Posts

Redshift

How to make an unconditional join in Redshift

LEFT OUTER JOIN ON 1=1 in Redshift
Published on: 17 Dec 2020

Redshift SQL

How to count the number of rows that match a condition in Redshift

How to count the rows by multiple conditions at the same time in SQL
Published on: 16 Dec 2020

Redshift

How to index data in Redshift

How to create an equivalent of an index in Redshift
Published on: 15 Dec 2020