Mega Code Archive
Categories
/
Oracle PLSQL
/
Date Timezone
NLS_DATE_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>