Is the ,141 part a fraction of a second? In 8i you could do:
to_date(substr('2003-02-07 11:20:17,141',1,19),'yyyy-mm-dd hh24:mi:ss') and
that would do (you would be missing the fraction of a second.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Marek Lange" <marek.lange_at_web.de> wrote in message
news:3E438A47.3090002_at_web.de...
> 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
>
Received on Fri Feb 07 2003 - 04:36:46 CST
