Oracle PL/SQL/Date Timezone/NLS DATE FORMAT

NLS_DATE_FORMAT: Find out system default data format

   <source lang="sql">

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>

      </source>