Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: date format
>> how do I make output as "02-MAR-05 12:20:00" without using to_char() process.
Set your NLS_DATE_FORMAT appropriately. e.g.
SQL> select sysdate from dual;
SYSDATE
Session altered.
SQL> select sysdate from dual;
SYSDATE