Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. Select round( sysdate, q ) Quarter
SQL>
SQL>
SQL> select round( sysdate, 'q' ) "Quarter"
  2  from dual
  3  /
Quarter
---------
01-JUL-08
1 row selected.
SQL>
SQL>
SQL> --