CodeFebruary 13, 2007 8:33 pm
Set default date format in Oracle sql*plus
You can change the default date format in Oracle SQL*Plus with the following command:
alter session set NLS_DATE_FORMAT=’<my_format>’;
For example,
alter session set NLS_DATE_FORMAT=’yyyy/mm/dd hh:mi:ssam’;
