3 Replies Latest reply: Aug 13, 2014 7:06 PM by Solomon Yakobson RSS

    Oracle Timestamp with just date

    Sri G

      Hi,

      I have a date field but it has to be showed in the report as follows -

       

      date - 2014-08-14 but it should be showed in the report as '2014-08-14 00.00.00.0000'

       

      select TO_CHAR(TO_DATE('2014-08-11','YYYY-MM-DD'),'YYYY-MM-DD HH24:MI:SSxFF') from dual   -- this doesnt work.

       

      any help appreciated.