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 -> Milliseconds and DATE field

Milliseconds and DATE field

From: Kim Hellan <khe_at_NOSPAMkmd.dk>
Date: Mon, 13 Dec 1999 09:03:04 +0100
Message-ID: <83297r$abt$1@news1.tele.dk>


Does the DATE field in Oracle8 support milliseconds ?

If yes, how do I use SQL to INSERT a record with a date/time value in the format 'YYYY-MM-DD hh:mm:ss:uuu', where uuu is the milliseconds ?

If no, is there another field type that supports milliseconds (like the DateTime field in an MS SQL Server) ?

TIA
Kim Hellan Received on Mon Dec 13 1999 - 02:03:04 CST

Original text of this message

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