NLS_DATE_FORMAT: Find out system default data format : NLS_DATE_FORMAT « Date Timezone « Oracle PL / SQL

1. Oracle PL / SQL
2. Date Timezone
3. NLS_DATE_FORMAT

NLS_DATE_FORMAT: Find out system default data format

SQL>
SQL> --Find the NLS_DATE_FORMAT:
SQL>
SQL> SELECT value FROM v$nls_parameters WHERE parameter ='NLS_DATE_FORMAT';

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

SQL>
           
       

Related examples in the same category