Proper use of default format mask : Date Default Format « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. Date Default Format

Proper use of default format mask

SQL> -- Proper use of default format mask.
SQL> SELECT TO_DATE('06-Jan-67') "Correct" from DUAL;

Correct
---------
06-JAN-67

SQL>








Related examples in the same category

1.Setting the Default Date Format
2.Insert date value along with the default date format
3.Default output of SYSDATE
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