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:
Comments are closed.

alex
alter session set nls_date_format = ‘DD-MON-RR’