Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error Non-numeric character in datetime or interval for tInformixInput

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

0683p000009M2im.pngError on the tInformixInput

0683p000009M2fj.pngMy query

Labels (2)
1 Reply
Anonymous
Not applicable
Author

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 🙂