Re: TO_CHAR(msg_date, 'HH24:MI:SS.FF')

  • 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.

--
//www.freelists.org/webpage/oracle-l

Other related posts: