select sysdate : SYSDATE « Date Timezone « Oracle PL / SQL






select sysdate

 
SQL>
SQL> select sysdate
  2  from dual
  3  /
SYSDATE
---------
16-JUN-08

1 row selected.

SQL> --

 








Related examples in the same category

1.Using the SYSDATE function: return the current date from the system
2.Get current operating system date
3.Combining TO_CHAR to Format SYSDATE
4.Removing the Time from SYSDATE
5.Truncating to the Quarter
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