| Change the format of sysdate [message #371386] |
Thu, 12 October 2000 01:55  |
Sushil
Messages: 16
Registered: October 2000
|
Junior Member |
|
|
Hi
Can i change the format of sysdate,so that while inserting the dates i need not use any conversion functions to change the format each time.
To be more clear. After settingup the sysdate.If i give the statement
select sysdate from dual;
this should return the date in the format i have set.
|
|
|
|
| Re: Change the format of sysdate [message #371394 is a reply to message #371386] |
Thu, 12 October 2000 10:34  |
Suresh
Messages: 189
Registered: December 1998
|
Senior Member |
|
|
you can change default date format for a particular session using
ALTER session set nls_date_format='dd/mm/yyyy'
or you can set initialization parameter
NLS_DATE_FORMAT = "dd/mm/yyyy" in intialization file.
Suresh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
