How to Alter Session Date Format in Oracle

Monday Apr 19th 2021 by Octavia Andreea Anghel
Article Image

Learn how to alter the date format at the session-level in Oracle in this quick database tutorial.

Altering the date format at session-level in Oracle can be achieve in the following manner:

ALTER SESSION SET nls_date_format = 'yyyy-MM-dd';
Mobile Site | Full Site