Re: HELP: DateTime problems

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 1998/01/03
Message-ID: <68k3j1$29i@mtinsc03.worldnet.att.net>#1/1

On 30 Dec 1997 16:24:08 GMT, "Alan D. Mills" <alanm_at_uk.europe.mcd.mot.com> wrote:

>In Oracle a date (including time) is stored as the number of days since the
>year dot (or whatever it is).

Actually, it's not. If you dig around in the Oracle doc set, you will find that the Oracle date/time type is stored as a string of bits. I forget just how many, but certain bits are allocated to the year, certain bits are allocated to the century, others to the month, others to the day, etc. Received on Sat Jan 03 1998 - 00:00:00 CST