title: How to use the date_trunc function for biweekly grouping
body: <p>I need to use the date_trunc function to group biweekly. </p>
  
  <p>The function, however, only have the options <strong>day</strong>, <strong>week</strong> and <strong>month</strong>. Does anyone know how to do it?</p>
  
  <p>Above the code I have for week:</p>
  
  <pre><code>(date_trunc('week', CAST((CAST("Account"."createdAt" AS timestamp) + INTERVAL '1 day') AS timestamp)) - INTERVAL '1 day')
  </code></pre>