title: How to get the quarter corresponding to a date in Oracle SQL 19c
body: <p>I think there was a function <strong>extract(quarter from <em>date</em>)</strong> in oracle sql to fetch the quarter for a given date. However the Oracle SQL 19c documentation <a href="https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/EXTRACT-datetime.html#GUID-36E52BF8-945D-437D-9A3C-6860CABD210E" rel="nofollow noreferrer">here</a> does not show the presence of <code>quarter</code> anymore.</p>
  <p>I even tried running the code -</p>
  <pre><code>select extract(quarter from to_date('15/09/2021','DD/MM/YYYY')) as Q from dual;
  </code></pre>
  <p>The expected result is -</p>
  <pre><code>+---+
  |  Q|
  +---+
  |  3|
  +---+
  </code></pre>
  <p>Instead it gives an error</p>
  <pre><code>ORA-00907 missing right parenthesis
  </code></pre>
  <p>though it runs fine when <code>quarter</code> is replaced by <code>month</code> or <code>year</code>. What is the current way to fetch <code>quarter</code> given a date in Oracle SQL 19c?</p>