Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.server -> how to store time with milliseconds in Oracle ?

how to store time with milliseconds in Oracle ?

From: Alain PIERRE <Groeps_at_mail.interpac.be>
Date: 10 Jul 1998 10:25:16 GMT
Message-ID: <01bdabed$b99090e0$2afa4ec2@internet>

Hi,

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

Patrick Wtterwulghe
Oracle DBA
Groupe-S Received on Fri Jul 10 1998 - 05:25:16 CDT

This message: [ Message body ]
Next message: Bram Stieperaere: "want to discuss: how to do a performant bitwise compare in a where clause"
Previous message: SIMBL: "HELP: SQLMENU 5.0 menu import missing items"
Next in thread: Jeremy Russell: "Re: how to store time with milliseconds in Oracle ?"
Reply: Jeremy Russell: "Re: how to store time with milliseconds in Oracle ?"
Reply: Hayden Worthington, Inc.: "Re: how to store time with milliseconds in Oracle ?"
Reply: Jonathan Gennick: "Re: 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