SYSDATE « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. SYSDATE
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.Truncating to the Quarter
7.Adding Two Months to SYSDATE
8.Adding One Month a certain date
9.Finding the First Monday After the Current Date and Time




10.use sysdate to init a variable
11.Minus days from sysdate