Oracle change the default date format before insert data

Oracle accepts date in the default format of YYYY-MON-DD. Here month is accepted as three characters of month name. Ex: January-JAN, February: FEB, etc

Now before executing a bulk records to a table with a required date format such as YYYY-MM-DD, we can alter the session to accept date in that format from the following query.

SQL> alter session set NLS_DATE_FORMAT='YYYY-MM-DD';

Now we can insert records with date represented in YYYY-MM-DD format.

Comments

Popular posts from this blog

PHP-SOAP web service with out a WSDL

Boomi Mapping - Removing special chars from an input

How to add Maven dependency from a relative path referencing a local jar