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