Re: default date format in 8i

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 14 Jan 2000 15:29:01 GMT
Message-ID: <85nfbt$p4m$2@news.seed.net.tw>

cbantzer <christian_bantzer_at_psmfc.org> wrote in message news:387D0539.68E03C66_at_psmfc.org...
> I just noticed that our 8i installation here seems to do an implicit
> to_date conversion even of a 4-digit year even though the default date
> format is dd-mon-yy
>
> I.e. I can do
>
> select foo from sometable
> where some_date > '1-dec-1999'
>
> and get the same as with
>
> select foo from sometable
> where some_date > to_date('1-dec-1999','dd-mon-yyyy')
>
> I am pretty sure the "where some_date > '1-dec-1999'" would have
> produced an error on 7.3
> Is this a documented "feature" of 8i?
>
> Btw. "where some_date > '1-dec-99'" works as expected too (i.e. expands
> the 99 to 2099)

Yes. It's a new feature in Oracle 8.0, not work in Oracle 7.x and before. Take a look at the Oracle8 SQL Reference manual. Received on Fri Jan 14 2000 - 09:29:01 CST