| Date Format [message #372323] |
Fri, 02 February 2001 10:26  |
May
Messages: 5
Registered: December 1998
|
Junior Member |
|
|
|
I put the NLS_DATE_FORMAT = 'YYYY/MM/DD HH24:MI:SS' in the INIT.ORA file to change the date format. However, when I tried doing an insert statement, it only accept DD-MMM-YY date format. How do I fix this problem?
|
|
|
|
| Re: Date Format [message #372324 is a reply to message #372323] |
Fri, 02 February 2001 10:54  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
Did you start the database after setting?
you can set nls_date_formate for your session using
alter session set nls_date_format='yyyy/dd/mm hh24:mi'
Suresh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
