Re: How to change the Default date format in Oracle and Developer 2000

From: Theo van Wieringen <theo.vanwieringen_at_bull.nl>
Date: 4 Jun 1999 11:05:43 GMT
Message-ID: <7j8bu7$5ch$1_at_trst.cca.vu.nl>


The format mask DD-MON-YY has a length of 9 characters, the DD-MM-YYYY mask has a length of 10 characters. Isn't that producing your error?
Look for the values of the properties Maximum Length and Query Length.

sajidhafeez_at_my-deja.com wrote in <7j2tlo$fg1$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 Hafeez
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jun 04 1999 - 13:05:43 CEST

Original text of this message