Re: 'Date' datatype question

SEVIRINA wrote:
>
> 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

Hi,

Q1:

        use to_date('10-01-1998','dd-mm-yyyy') f.e.

Q2:

        No, Oracle Version 7.X always store year as 'yyyy'

Q3:

        in your apps use only year-format 'yyyy'

-- 
Regards

Matthias Gresz    :-)