Default output of SYSDATE : Date Default Format « Date Timezone « Oracle PL / SQL






Default output of SYSDATE



SQL>
SQL>
SQL> -- Default output of SYSDATE.
SQL> SELECT SYSDATE from DUAL;

SYSDATE
---------
31-AUG-06

SQL>
SQL>
           
       








Related examples in the same category

1.Setting the Default Date Format
2.Insert date value along with the default date format
3.Proper use of default format mask
4.Get NLS date format: V$NLS_Parameters
5.Simple Examples of Storing and Retrieving Dates
6.Use the DATE keyword to supply a date literal to the database