1 Reply Latest reply: Jan 21, 2013 10:52 PM by Bhabani Ranjan RSS

    ORA-01843: not a valid month

      I am converting my data into date format. The column name is 'LAST_TRADE_DATE' and current format is 'mm/dd/yyyy'. In the source table its datatype is VARCHAR2 In the target table I have taken DATE data type. and to convert the data into date format I have used sql code as 'TO_DATE(TABLENAME.LAST_TRADE_DATE,'MM/DD/YYYY')'. When i run this code in sql developer it is giving proper data. But in ODI studio it is giving error as 'ORA-01843: not a valid month'.Can anyone please tell me the solution for this problem?