On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

Saturday, August 9, 2008

Change Basic Date Format

SQL> select '&_date' from dual;

09-AUG-08

SQL> alter session set nls_date_format = 'mm/dd/yyyy hh24:mi:ss';

SQL> select '&_date' from dual;

08/09/2008 16:20:03

No comments:

Post a Comment