Truncating to the Quarter : SYSDATE « Date Timezone « Oracle PL / SQL






Truncating to the Quarter

 
SQL> --
SQL>
SQL> SELECT TO_CHAR(TRUNC(SYSDATE,'Q'),'MM/DD/YYYY HH:MM:SS AM')
  2      "Today's Date and Time"
  3   from DUAL
  4
SQL> --

 








Related examples in the same category

1.select sysdate
2.Using the SYSDATE function: return the current date from the system
3.Get current operating system date
4.Combining TO_CHAR to Format SYSDATE
5.Removing the Time from SYSDATE
6.Adding Two Months to SYSDATE
7.Adding One Month a certain date
8.Finding the First Monday After the Current Date and Time
9.use sysdate to init a variable
10.Minus days from sysdate