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: Latest Date..

Re: Latest Date..

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 16 Feb 2005 09:50:46 +0100
Message-ID: <cuv1h7$1rt$1@news.BelWue.DE>


arijitchatterjee123_at_yahoo.co.in wrote:
> Dear Sir,
> Thanks for your reply.But is is there any way or query to identify
> that???
> Regards
> Arijit Chatterjee
>

Two ways spring to mind: why don't you just try it (with the highest date you're anticipating in your application) by creating a table wich contains a single date column and insert into that?

Of course the better way would be to Read The Fine Manual (TM), the OCI Programmers Guide contains a description of the internal representation. The date Jim meant was probably 01-JAN-4712 BCE wich is the first day of the julian calendar - according to the said documentation.

Neither my math nor my understanding are exceptionally well, but the representation of the date type seems to allow a date beyond 31.12.9999, however, it seems oracle put a restriction onto that:

baer_at_DEMO10G>select to_date ('31.12.9999', 'dd.mm.yyyy') from dual;

TO_DATE('



31-DEC-99 baer_at_DEMO10G>select to_date ('31.12.9999', 'dd.mm.yyyy')+1 from dual; select to_date ('31.12.9999', 'dd.mm.yyyy')+1 from dual
                                            *
ERROR at line 1:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

HTH
Holger Received on Wed Feb 16 2005 - 02:50:46 CST

Original text of this message

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