https://community.qlik.com/t5/Talend-Studio/date-conversion-issue/m-p/2272477#M49740 Good morning, <BR />I would like to generate a file that contains dates like this pattern DD / MM / YYYY but when generating the query with component tOracleInput with the date that I have the following form : Tue Oct 23 00:00:00 CEST 2008 .. I realize therefore to_char (date, 'DD / MM / YYYY HH24: MI: SS') in the tOracleInput and I get the following exception: <BR />Except in Component tOracleInput_1 <BR />java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh: mm: ss.fffffffff <BR /> at java.sql.Timestamp.valueOf (Unknown Source) <BR /> at oracle.jdbc.driver.CharCommonAccessor.getTimestamp (CharCommonAccessor.java: 485) <BR />Could you help me ? <BR />Thank you. Sat, 16 Nov 2024 14:16:54 GMT _AnonymousUser 2024-11-16T14:16:54Z https://community.qlik.com/t5/Talend-Studio/date-conversion-issue/m-p/2272477#M49740 Good morning, <BR />I would like to generate a file that contains dates like this pattern DD / MM / YYYY but when generating the query with component tOracleInput with the date that I have the following form : Tue Oct 23 00:00:00 CEST 2008 .. I realize therefore to_char (date, 'DD / MM / YYYY HH24: MI: SS') in the tOracleInput and I get the following exception: <BR />Except in Component tOracleInput_1 <BR />java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh: mm: ss.fffffffff <BR /> at java.sql.Timestamp.valueOf (Unknown Source) <BR /> at oracle.jdbc.driver.CharCommonAccessor.getTimestamp (CharCommonAccessor.java: 485) <BR />Could you help me ? <BR />Thank you. Sat, 16 Nov 2024 14:16:54 GMT https://community.qlik.com/t5/Talend-Studio/date-conversion-issue/m-p/2272477#M49740 _AnonymousUser 2024-11-16T14:16:54Z https://community.qlik.com/t5/Talend-Studio/date-conversion-issue/m-p/2272478#M49741 Hello <BR />Set the data type of 'date' column as String when defining the schema of tOracleInput component, then link to a tMap/tJavaRow, convert this string to a date: <BR /> <PRE>TalendDate.parseDate("EEE MMM dd HH:mm:ss zzzz yyyy",row1.date)</PRE> <BR />Best regards <BR /> <BR /> shong Mon, 28 Jul 2008 03:56:00 GMT https://community.qlik.com/t5/Talend-Studio/date-conversion-issue/m-p/2272478#M49741 Anonymous 2008-07-28T03:56:00Z