Re: FORMS45 Format Mask

I dont have to much to offer but... I believe if you do not specify a date format when selecting date fields in SQL, 01-JAN-97 is the default appearance. However the century and the year are stored. If you specify DD-MM-YYYY when you do the select, it will show all 4 digits for the year. They are always stored, just not always seen.

Why your getting 01/11/0097 is confusing. Where did the 11 come from? If the format is yyyy, the century should always be 19. If you use RR rather than yy, Oracle, in its great intelligence, will look at the two digits and if they are > 50 will make them current centur. If they are < 50 it will convert them to the century 2000. Good luck.
Jeff

On Wed, 17 Sep 1997 17:35:44 GMT, am_balshem_at_fccc.edu (Andrew M. Balshem) wrote:

>
>We've recently converted forms from version 3.0 to 4.5 and noticed
>that the format mask (for date fields) mm"/"dd"/"yyyy no longer works
>correctly unless you completely enter all the necessary information.
>What I mean is: in version 3 we could enter the date January 1, 1997
>as 01011997 and the format mask would mask as 01/01/1997 and record in
>the database as 01-JAN-97. In version 4.5 entering the date as above
>the mask appears as 01/11/0097. Anyone else have similiar situation
>and gotten a work around other than entering the dashes (no big deal
>but a bother to our data entry personnel.)
Received on Wed Sep 17 1997 - 00:00:00 CEST