Get current operating system date : SYSDATE « Date Timezone « Oracle PL / SQL






Get current operating system date


SQL>
SQL> SELECT SYSDATE FROM dual;

SYSDATE
---------
30-AUG-06

SQL>
SQL>

           
       








Related examples in the same category

1.select sysdate
2.Using the SYSDATE function: return the current date from the system
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