Get NLS date format: V$NLS_Parameters : Date Default Format « Date Timezone « Oracle PL / SQL






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

Get NLS date format: V$NLS_Parameters


SQL>
SQL> -- Get NLS date format: V$NLS_Parameters.
SQL>
SQL> SELECT value FROM V$NLS_Parameters WHERE parameter ='NLS_DATE_FORMAT';

VALUE
----------------------------------------------------------------
DD-MON-RR








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.Default output of SYSDATE
5.Simple Examples of Storing and Retrieving Dates
6.Use the DATE keyword to supply a date literal to the database