How to set date format in all exports Oracle SQL

In order to recognize ms excel date format when you export-it you must set the session nls_date_format according to the one set on your PC in Windows.

alter session set nls_date_format = ‘mm/dd/yyyy’;

Comment:
  • alter session set nls_date_format = ‘DD-MON-RR’

Comments are closed.