3 Replies Latest reply on Aug 14, 2014 12:06 AM by Solomon Yakobson

    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.