| query [message #7592] |
Tue, 24 June 2003 00:01  |
rajool
Messages: 13
Registered: May 2003
|
Junior Member |
|
|
Hi all,
i have one query.
i want to get the sysdate in date format.
without using to_char and to_date function.
dd/mm/yyyy in this format can anybody help me.
24/jun/2003 like this.
Bye,
|
|
|
|
| Re: query [message #7607 is a reply to message #7592] |
Tue, 24 June 2003 15:37  |
 |
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'dd/mm/yyyy';
Session altered.
SQL> SELECT SYSDATE FROM DUAL;
SYSDATE
----------
24/06/2003
SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'dd/mon/yyyy';
Session altered.
SQL> SELECT SYSDATE FROM DUAL;
SYSDATE
-----------
24/jun/2003
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
