Re: Microseconds in Oracle
From: Brian McCabe <brian_at_mitc.demon.co.uk>
Date: 1996/07/01
Message-ID: <vKs97BAbX71xEwAX_at_mitc.demon.co.uk>#1/1
Date: 1996/07/01
Message-ID: <vKs97BAbX71xEwAX_at_mitc.demon.co.uk>#1/1
In article <4r3f6v$r2k_at_newsbf02.news.aol.com>, Debor19071
<debor19071_at_aol.com> writes
>Yes!!
>
>If you do a TO_CHAR(sysdate, 'yyyy-mm-dd-hh:mm:ss:mmmm') - this displays
>down to milliseconds...
>
>Deb
No! The above statement will return what, at first, looks like microseconds - in actual fact is the month twice!
-- Brian McCabe McCabe IT Consulting Limited brian_at_mitc.demon.co.ukReceived on Mon Jul 01 1996 - 00:00:00 CEST