7 Replies Latest reply: Dec 14, 2010 11:41 AM by Héctor Muñoz RSS

    To_Date from a Timestamp field....

      I've tried to use that query but it seems that it doesn't accept the TIMESTAMP format of date field:

      LOAD HOST, DATE_C;
      SQL SELECT HOST, TO_DATE(DATE_C,'AAAA-MM-DD hh:mm:ss.fff')
      from TABLE1;

      Ans this is the error: SQL##f - SqlState: S1000, ErrorCode: 1821, ErrorMsg: [Oracle][ODBC][Ora]ORA-01821: date format not recognized

       

      ANy ideas?