Re: SQL

Just to clarify,
is Feb 29, 2000 displayed as 29-Feb-0 ( since this does not match the format you listed) and, in the same display field, Jan 24, 2000 shown as 01/24/00 ( which does match the format)?

If so, set the format to some other ( like 'MON-DD-YYYY') widen the field and see what happens....

Just be sure the display field is wide enough to show all possible values of the date...

DS <danny118_at_REMOVEMEhotmail.com> wrote:

>Hello!
>
> Platform: SQL*Forms 3.0
> Oracle DB 7.3
>
>We have a form containing a display only (non-updatable, non-enterable)
>date field with an ouput mask of MM/DD/YY. When the form retrieves
>a record in the DB with a value of Feb. 29, 2000, it is displayed in the
>form as 29-Feb-0. Any other dates in the yr 2000 works (Jan 24, 2000
>is displayed as 01/24/00). Has anybody encountered this weird behavior?
>We have checked that the value in the DB is indeed Feb 29, 2000 and
>not Feb 29, 0000 thru SQLPLUS.
>
>Any solutions/help for this is appreciated.
>
>Thanks.
>
>PS. Remove REMOVEME from email address....

To reply please remove the 'nospam' part of the address Received on Wed Feb 10 1999 - 00:00:00 CST