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’;
The URI to TrackBack this entry is: http://jdev.blogsome.com/2007/02/13/set-default-date-format-in-oracle-sqlplus/trackback/
No comments yet.
RSS feed for comments on this post.
Line and paragraph breaks automatic, e-mail address never displayed, HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>
