3 Replies Latest reply: Jan 31, 2013 10:26 AM by Solomon Yakobson RSS

    ORA-01830: date format picture ends before converting entire input string

    780611
      Hi Masters!

      I am running following statement

      select TO_DATE( TO_CHAR(CAST((B.EOAWDTTM_MODIFIED) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'),'YYYY-MM-DD') from PS_SR_EX_ER_AW_VW B where rownum < 5

      and It gives me the error

      ORA-01830: date format picture ends before converting entire input string
      01830. 00000 - "date format picture ends before converting entire input string"

      Any idea? Thank you all!