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

    Converting number to date




      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.