Error Non-numeric character in datetime or interval for tInformixInput

[Anonymous]

Hello 

I'm getting an error when trying to use my global variable (already set) in tInformixInput. The datatype of my variable is Datetime. Please see below error screenshot

Error on the tInformixInput

My query

[Anonymous]

Hi,

    It is saying that the data you are giving as parameter is not in date time format for Informix.

    Could you please use the input data as String and use date convert functions in the SQL to fix it?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂