Re: 'date' datatype question

just do this :
make a mask for your textfield to
"DD-MON-YYYY"
and oracle will handle your 4 digits year .. and if you want to show it in 4 digits too set your mask too.

SEVIRINA wrote in message <19971129084401.DAA20606_at_ladder01.news.aol.com>...
>I've got a date datatype. I defined it at 'date' during creation of tables.
>
>Basically, I want to be able to be y2k compliant therefore, want to be able
 to
>handle 4 digit years.
>
>#1: How do I get it to take "10-Jan-1998" instead of "10-Jan-98" ?
>
>#2: Do I even have to worry about that at all, i.e. Oracle 7 already takes
 all
>years and stores as 4 digit yrs.
>
>#3: If so, entering "10-Jan-00" will make sense and after input, doing an
 order
>will show "00" as the latest year.
>
>Any help would be appreciated, pls respond via email: sevirina_at_aol.com
>
>Thanks
>
Received on Mon Dec 01 1997 - 00:00:00 CET