Connector reply error: ErrorSource: IBM OLE DB Provider, ErrorMsg: [DB2] SQL0180N The syntax of the string representation of a datetime value is incor

[DhanaC]

HI All,

Happy New Year, I am new to the community & to the tool.

Facing issue while passing the parameter.  Source DB - DB2.

Error Meaasge:

Connector reply error: ErrorSource: IBM OLE DB Provider, ErrorMsg: [DB2] SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007

Did anyone faced similar issue. Tried converting into different formats but facing the issue. Any solution?

Thanks in Advance

[john_wang]

Hello @DhanaC ,

Welcome to Qlik Community forum and thanks for reaching out here!

I'm afraid Qlik Replicate does not use the "IBM OLE DB Provider". Would you please share what's the DB2 platform (DB2i, DB2z, or DB2 LUW), and version number, and also the Qlik Replicate version number?

In Qlik Replicate, the ODBC Driver is used to connect to DB2.

Regards,

John.

[DhanaC · Accepted solution]

Forgot to update the thread.

Issue got resolved by using the below format

VARCHAR_FORMAT(TIMESTAMP_FIELD_NAME,'YYYY-MM-DD HH:MI:SS AM')

[Dana_Baldwin]

Thank you @DhanaC !