get previous month start date and end date in sql redwhift code example Example: sql beginning of previous month SELECT DATEADD(d,1,EOMONTH(GETDATE(),-2))