RSA Scripts

Change NLS_DATE_FORMAT

Change NLS_DATE_FORMAT.

  1. Oracle
  2. Date manipulation
  3. Beginner
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

ALTER SESSION SET NLS_DATE_FORMAT = 'dd/mm/yyyy';
select sysdate from dual;
ALTER SESSION SET NLS_DATE_FORMAT = 'dd-mon-yyyy';
select sysdate from dual;
ALTER SESSION SET NLS_DATE_FORMAT = 'yyyymmdd';
select sysdate from dual;