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 -> Re: Date conversion

Re: Date conversion

From: Rob Cowell <rjc4687_at_hotmail.com>
Date: Fri, 07 Feb 2003 11:18:10 +0000
Message-ID: <3E4395F2.9F953EBA@hotmail.com>

Marek Lange wrote:
>
> Hi all,
>
> is there a way to convert the string
>
> 2003-02-07 11:20:17,141
>
> (log4j output) to the Oracle 'Date' datatype?
>
> Thanks,
>
> Marek

If you are using a version 9 RDBMS you can make use of the TIMESTAMP datatype which will store fractions of a second. DATE will not store to a greater precision than a second. Received on Fri Feb 07 2003 - 05:18:10 CST

Original text of this message

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