Re: how to store time with milliseconds in Oracle ?

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sun, 12 Jul 1998 04:38:44 GMT
Message-ID: <6o9eki$3pm@bgtnsc03.worldnet.att.net>

On 10 Jul 1998 10:25:16 GMT, "Alain PIERRE" <Groeps_at_mail.interpac.be> wrote:

>I have to store time HH:MM:SS + milliseconds in Oracle.
>Is there an easy way to do this ? No date format seems to support that.
>DATE is 7-byte fixed

Oracle DATE fields only go down to seconds, so if you need milleseconds, you will need a seperate field.

Jonathan Received on Sat Jul 11 1998 - 23:38:44 CDT

This message: [ Message body ]
Next message: kimcd_at_shinbiro.com: "[Q]Delete error?"
Previous message: Jonathan Gennick: "Re: How i can do a recursive sql query"
In reply to: Alain PIERRE: "how to store time with milliseconds in Oracle ?"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US