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'))
Clicking the newsletter button opens a separate page hosted by ActiveCampaign with a Google Captcha. You will get their cookies.
It has to be a separate page because many spam bots subscribed recently, so I must filter them out using a Captcha. Unfortunately, Captcha requires cookies, and I don't want any cookies (especially third-party cookies) used on this page.
LEFT OUTER JOIN ON 1=1 in Redshift
Published on: 17 Dec 2020
How to count the rows by multiple conditions at the same time in SQL
Published on: 16 Dec 2020
How to create an equivalent of an index in Redshift
Published on: 15 Dec 2020