Re: Internal date format (numerical)

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 30 Nov 2005 13:55:18 -0500
Message-ID: <vICdnZTRL-8FaBDeRVn-vQ@comcast.com>

"Guy" <guhar1_at_yahoo.com> wrote in message news:1133376183.008901.295930_at_g47g2000cwa.googlegroups.com...
> Yes. I also figured out that the base date for all internal date format
> seems to be '30-12-1899', for oracle
>
> Its 1-1-1900 for Sql Server. Which seems logical.
>
> Wonder how Oracle could came up with a date "base" like that?
>

oracle didn't -- delphi did. your calculation has nothing to do with the way oracle dates are implemented, you're trying to apply another product's logic

oracle dates don't have a 'base' figure -- their internal storage has individual components for each part of the date from year to second -- check out the docs.

++ mcs Received on Wed Nov 30 2005 - 12:55:18 CST