[Q]How to change the default date format?

From: <sajidhafeez_at_my-deja.com>
Date: Thu, 03 Jun 1999 05:48:58 GMT
Message-ID: <7j5508$74u$1_at_nnrp1.deja.com>



[Quoted] 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 - 07:48:58 CEST

Original text of this message