SQL

From: DS <danny118_at_REMOVEMEhotmail.com>
Date: 1999/02/09
Message-ID: <36C0B1ED.D8B614B@REMOVEMEhotmail.com>#1/1

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.... Received on Tue Feb 09 1999 - 00:00:00 CST