SAP Knowledge Base Article - Preview

3698593 - SAP IQ -'1753-01-01' is returned instead of the stored value '1111-01-01' when connecting to SAP IQ database using jConnect

Symptom

  • When connecting to SAP IQ database using jConnect, the "date" data type returns '1753-01-01' instead of the stored value '1111-01-01'.
  • This issue does not occur when connecting to SAP IQ database using ODBC.
  • The issue persists even after applying the latest "jconn42.jar".


Read more...

Environment

  • SAP IQ 16.1
  • jConnect (TM) for JDBC(TM)/16.1 SP00 PL01/P/EBF31167/jdbc161/OPT/Fri Jul 25 00:41:44 PDT 2025
  • DBeaver 25.2.5

Product

SAP IQ 16.1

Keywords

jConnect, JDBC driver, SAP IQ, date data type, incorrect date values, 1753-01-01, 1111-01-01, ODBC, jconn42.jar, SAP ASE, date issue, database connection , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.