Ask your DBA to change the Init<sid>.ora to set the
date format as you want.
sajidhafeez_at_my-deja.com wrote in message <7j56e6$7ga$1_at_nnrp1.deja.com>...
>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 Sun Jun 06 1999 - 10:24:05 CDT
