Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> [Q] How to change the default date format?
Hi all
I am facing a problem while developing an application in Developer 2000
and Oracle 8.
That is, in the form I had bind a field with a database column, having
date data type, now the problem is with Oracle’s default date format
which is DD-MON-YY and I want to show it in DD-MM-YYYY format. If I
change the mask of the control in forms it gives error and doesn’t
display the date.
I also read about the DBMS_SESSION package having SET_NLS procedure,
which is equivalent to SQL command ALTER SESSION, but it couldn’t be
used in Triggers.
Best regards
Sajid
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Thu Jun 03 1999 - 01:13:30 CDT