redshift date functions

select getdate();

getdate

2020-05-27 06:44:07

—

select

getdate() as today,

date(dateadd(‘year’,-1,(last_day(dateadd(‘month’,-1,getdate()))))):: DATE as date1,

date(last_day(dateadd(‘month’,-1,getdate())))::DATE as date2;