5 Replies Latest reply: Sep 20, 2013 12:42 AM by Soofi RSS

    Error "Not a Valid Month"

    lgrmyoao

      I'm trying to change a date but keep getting the error "Not a Valid Month".  I want to change a date such as 7/23/2012 to JUL_12.

      This is what I'm currently doing:

       

      UPDATE DISREQ DRQ 

      SET DRQ.REQUEST_DATE = 

      SUBSTR(TO_CHAR(TO_DATE(DRQ.REQUEST_DATE, 'MM/DD/YY')), 4, 3 ) || '_' || SUBSTR(TO_CHAR(TO_DATE(DRQ.REQUEST_DATE, 'MM/DD/YY')), 8 )

       

       

      Any help would appreciated.