Re: How to design schema for time information
Date: Thu, 06 Mar 2008 19:55:30 +0100
> I am wondering if there is a better way to define a column to store
> time information.
As far as Oracle is concerned, there is only one way to store data like yours: use a DATE datatype. In contrast to what you assume, DATE datatype stores date as well as time components, up to a second.
Time to read up on the datatypes in Oracle, the documentation starts at http://tahiti.oracle.com
-- Regards, Frank van Bortel Top-posting in UseNet newsgroups is one way to shut me upReceived on Thu Mar 06 2008 - 12:55:30 CST