Re: Microseconds in Oracle
From: Charles Jardine <cj10_at_cam.ac.uk>
Date: 1996/07/01
Message-ID: <31D7B5BE.62EC_at_cam.ac.uk>#1/1
1996-07-01-12:07:50:0707
Date: 1996/07/01
Message-ID: <31D7B5BE.62EC_at_cam.ac.uk>#1/1
Debor19071 wrote:
>
> Yes!!
>
> If you do a TO_CHAR(sysdate, 'yyyy-mm-dd-hh:mm:ss:mmmm') - this displays
> down to milliseconds...
>
> Deb
Good God!
TO_CHAR(SYSDATE,'YYYY-MM-DD-HH:MM:SS:MMMM')
1996-07-01-12:07:50:0707
^^ ^^ ^^^^
Four copies of the month!
Received on Mon Jul 01 1996 - 00:00:00 CEST