SQL

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

Hello!

Platform: SQL*Forms 3.0

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.

PS. Remove REMOVEME from email address.... Received on Tue Feb 09 1999 - 00:00:00 CET

This message: [ Message body ]
Next message: yewpc_at_my-dejanews.com: "Re: Weird behavior of the table with unique index"
Previous message: David Lee: "Oracle's db_block_size questions.."
Next in thread: Pam Himes: "Re: SQL"
Reply: TurkBear: "Re: SQL"
Reply: Gitte Tøgersen: "Re: SQL*Forms 3.0 displaying dates in Y2K"
Reply: Pam Himes: "Re: SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message