Re: How to design schema for time information

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 06 Mar 2008 19:55:30 +0100
Message-ID: <ba51e$47d03e22$524b5c40$29663@cache5.tilbu1.nb.home.nl>

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 http://tahiti.oracle.com

-- 

Regards,
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

This message: [ Message body ]
Next message: joel garry: "Re: History behind 30 character name limit?"
Previous message: Mark D Powell: "Re: History behind 30 character name limit?"
In reply to: Jason: "How to design schema for time information"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message