Re: Microseconds in Oracle

Vijay Vardhineni 604-1835 <vvardh01> wrote:
>This is a multi-part message in MIME format.
>
>---------------------------------189548178870758499620551264
>Content-Transfer-Encoding: 7bit
>Content-Type: text/plain; charset=us-ascii
>
>I tried to select milliseconds using TO_CHAR(sysdate,
>'yyyy-mm-dd-hh:mi:ss:mmmm') It is not working.
>
>for 'mmmm' I am getting the value of the month two times, not
>the milliseconds.
>
>vijay
>

Vijay,

This was posted in this newsgroup by someone from Oracle Corporation.

select to_char(sysdate,'DD-MON-YYYY hh24:mi:ss:' ) || mod(hsecs,100) from v$timer;

Hope this helps;

Naren Chintala
naren_at_mink.att.com Received on Wed Jul 03 1996 - 00:00:00 CEST