Re: How to design schema for time information

From: Frank van Bortel <>
Date: Thu, 06 Mar 2008 19:55:30 +0100
Message-ID: <ba51e$47d03e22$524b5c40$>

Jason wrote:
> 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


Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Thu Mar 06 2008 - 12:55:30 CST

Original text of this message