Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DATE datatype in Oracle7

Re: DATE datatype in Oracle7

From: Norman Neil <obspg_at_mag-net.com>
Date: 1997/11/21
Message-ID: <01bcf6af$f3230700$299ff4cc@fswcnslt.northwood.ca>#1/1

Are you storing date with a timestamp of - anything? I don't see the relevance ot testing where
the end point of the century exists? Are you writing an app that will survive past the year 4712?
I don't think so....

So the question is: what's your point?

> but the documentation says:
>
> -4713 < YYYY <= 4712
>
> Also, the year 0 causes an error on insert
> (I think, that's a correct behavior), but
> allows it to be calculated (via update).
>
> Where is the bug, where is the feature?
>
> Steffen
>
Received on Fri Nov 21 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US