Re: Internal date format (numerical)

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 02 Dec 2005 15:50:18 -0800
Message-ID: <1133567404.436601@jetspin.drizzle.com>

Turkbear wrote:

>>Normally, there is little reason to use the DATE datatype.
>>=========================================================================
>>Source:
>>http://www.cs.umb.edu/cs634/ora9idocs/appdev.920/a97269/pc_04dat.htm

>
>
>
> Do you really believe that
> 'Normally, there is little reason to use the DATE datatype.'..?

When you've got timestamp? Absolutely.

> I have always been taught to use the datatype that matches the use of the data..so use DATE for any entry that will be used
> in Date math ( like computing time spans or someone's age)..
>
> Seems odd not to use it...

But why not build in the capability to gain timezone and fractional seconds later if required?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Fri Dec 02 2005 - 17:50:18 CST