https://community.qlik.com/t5/Talend-Studio/Error-Non-numeric-character-in-datetime-or-interval-for/m-p/2235253#M24341 <P>Hi,</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; It is saying that the data you are giving as parameter is not in date time format for Informix.</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; Could you please use the input data as String and use date convert functions in the SQL to fix it?</P> <P>&nbsp;</P> <P>Warm Regards,<BR />Nikhil Thampi</P> <P>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 <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 08 Mar 2019 11:53:49 GMT Anonymous 2019-03-08T11:53:49Z https://community.qlik.com/t5/Talend-Studio/Error-Non-numeric-character-in-datetime-or-interval-for/m-p/2235252#M24340 <P>Hello&nbsp;</P> <P>&nbsp;</P> <P>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</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Error on the tInformixInput" style="width: 616px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M2im.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/135312i9F9492BF22C60676/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M2im.png" alt="0683p000009M2im.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">Error on the tInformixInput</SPAN></SPAN></P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="My query" style="width: 394px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M2fj.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128317i29B447C7B67D17C8/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M2fj.png" alt="0683p000009M2fj.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">My query</SPAN></SPAN></P> Fri, 08 Mar 2019 11:40:50 GMT https://community.qlik.com/t5/Talend-Studio/Error-Non-numeric-character-in-datetime-or-interval-for/m-p/2235252#M24340 Anonymous 2019-03-08T11:40:50Z https://community.qlik.com/t5/Talend-Studio/Error-Non-numeric-character-in-datetime-or-interval-for/m-p/2235253#M24341 <P>Hi,</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; It is saying that the data you are giving as parameter is not in date time format for Informix.</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; Could you please use the input data as String and use date convert functions in the SQL to fix it?</P> <P>&nbsp;</P> <P>Warm Regards,<BR />Nikhil Thampi</P> <P>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 <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 08 Mar 2019 11:53:49 GMT https://community.qlik.com/t5/Talend-Studio/Error-Non-numeric-character-in-datetime-or-interval-for/m-p/2235253#M24341 Anonymous 2019-03-08T11:53:49Z