DATE Format [message #1946] |
Wed, 12 June 2002 07:31 |
Krina
Messages: 1 Registered: June 2002
|
Junior Member |
|
|
I am working on ASP pages, and when a date is diplayed from the db, its in a mm/dd/yy. How do I change either the input of dates in the db to be mm/dd/yy or change the output of dates to be dd-mon-yy?
|
|
|
Re: DATE Format [message #1948 is a reply to message #1946] |
Wed, 12 June 2002 07:51 |
motiram
Messages: 21 Registered: January 2001
|
Junior Member |
|
|
The default nls_date_format setting for your session.
You can change your session by
alter session set nls_date_format='YYYY-MM-DD'
If you are accessing from ASP pages, you need to format it before you put or get from DB.
select to_char(sysdate,'MM/DD/YY') from dual
|
|
|