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