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