What Is Default Date Format In Oracle?

1. Introduction

In this article, we will discuss about the default date format in Oracle, How to change it with examples.

Default date format of Oracle database is DD-MON-RR where RR refers to a two digit year.

To summarize, we have seen the details about the default date format in Oracle, how to change the default date format.

ALTER SESSION SET nls_date_format = ‘DD/MM/YYYY’;

SELECT * FROM nls_session_parameters where paramter = ‘NLS_DATE_FORMAT’;

Select SYSDATE from dual;

ALTER SYSTEM SET nls_date_format =’DD/MM/YYYY’ scope=both;

INSERT INTO tablename(Date_Column_name) VALUES(TO_DATE(’17/12/2020′, ‘DD/MM/YYYY’));