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

    Oracle Timestamp with just date

    Sri G


      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'


      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.