1 Reply Latest reply on Aug 15, 2016 6:43 AM by Andrew Watson

    Converting number to date

    SAMSUNDER GADIRAJU

      Hi,

       

      I want to convert a number format YYYYMMDD stored in oracle to date format and use this for Trend reporting.I am receiving the below error

       

      Oracle database error 1830: ORA-01830: date format picture ends before converting entire input string

       

       

      Appreciate any suggestions to handle this.