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


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.uk
Received on Mon Jul 01 1996 - 00:00:00 CEST

Original text of this message