'Timestamp without timezone' DB type does not work with tRedshiftInput Schema in Talend Studio 7.1.1

[BI1]

Hi, 

In tRedshiftInput , I want to read data of Timestamp type in Database (yyyy-mm-dd HH:mm:ss) . When I put the data type as Timestamp without timezone and give format as "yyyy-MM-dd HH:mm:ss" , it gives error :-

[Amazon][JDBC](10140) Error converting value to Timestamp.
at com.amazon.exceptions.ExceptionConverter.toSQLException(Unknown Source)
at com.amazon.utilities.conversion.TypeConverter.convertToTimestamp(Unknown Source)
at com.amazon.utilities.conversion.TypeConverter.toTimestamp(Unknown Source)
at com.amazon.jdbc.common.SForwardResultSet.getTimestamp(Unknown Source)
at routines.system.JDBCUtil.getDate(JDBCUtil.java:61) ....

The same operation and query worked well when the job was complied and built in T6.5 Version . Can you please help?

[akumar2301]

workaround :
if nothing works out , convert your timestand col to Char and read it in Talend

https://docs.aws.amazon.com/redshift/latest/dg/r_TO_CHAR.html