From: david wendelken <davewendelken@xxxxxxxxxxxxx>
To: GLeonard@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Date: Thu, 20 Jan 2005 00:55:16 -0500 (GMT-05:00)
This works:
select TO_CHAR(systimestamp, 'HH24:MI:SS.FF4') from dual
This doesn't:
select TO_CHAR(sysdate, 'HH24:MI:SS.FF4') from dual
So my guess is that msg_date is the wrong datatype.
--
http://www.freelists.org/webpage/oracle-l