title: How to Get First and Last Day of a Quarter in Vertica
body: <p>I need to rewrite code from SQL server to Vertica. </p>
  
  <p><code>SELECT DATEADD(qq, DATEDIFF(qq, 0, GETDATE()), 0)</code> - i need to get first date of quarter</p>
  
  <p><code>SELECT DATEADD (dd, -1, DATEADD(qq, DATEDIFF(qq, 0, GETDATE()) +1, 0))</code>- last date</p>