Re: Microseconds in Oracle

From: Jayendran Kannan <kannanj_at_detroitedison.com>
Date: 1996/07/01
Message-ID: <31D801EA.4335_at_detroitedison.com>#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

I don't think this is going to work.
First of all, "mm" denotes month number, not minutes (which is "mi")

The following sql statement will prove the above argument.

---

select TO_CHAR(sysdate, 'yyyy-mm-dd-hh:mm:ss:mmmm') from dual;

TO_CHAR(SYSDATE,'YYYY-MM-DD-HH:MM:SS:MMMM')

---

1996-07-01-12:07:16:0707

---

select TO_CHAR(sysdate, 'YYYY-MM-DD-HH:MI:SS') from dual;

TO_CHAR(SYSDATE,'YYYY-MM-DD-HH:MI:SS')

---

1996-07-01-12:48:13 Received on Mon Jul 01 1996 - 00:00:00 CEST