Re: TO_DATE

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/03/30
Message-ID: <954411251.27671.0.pluto.d4ee154e@news.demon.nl>#1/1

Oracle doesn't capture fractions of a second, so the answer is no, you can't do that.

Sorry,

Sybrand Bakker, Oracle DBA

Susana Mila <susi_at_olemail.com> wrote in message news:8bv4vh$3am$1_at_diana.bcn.ttd.net...
> Hi to the people's news,
>
> I don't konw if it's possible to express the first decimal in the seconds,
> for example the function:
>
> TO_DATE('2000-03-29 17:37:20.0','YYYY-MM-DD HH24:MI:SS')
>
> is incorrect, I need to know how I can do that,
>
> Thanks, bye.
>
>
Received on Thu Mar 30 2000 - 00:00:00 CST