SAP Knowledge Base Article - Preview

2567217 - DateAdd function returns "out of range" error - SQL Anywhere

Symptom

Error:

  • Value dateadd(month,0,0001-01-01 00:00:00.000) out of range for
    destination
    SQLCODE=-158, ODBC 3 State="22003"
    Line 1, column 1
  • Value dateadd(quarter,0,0001-01-01 00:00:00.000) out of range for
    destination
    SQLCODE=-158, ODBC 3 State="22003"
    Line 1, column 1


Read more...

Environment

SAP SQL Anywhere - all versions

Product

SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0 ; SAP Sybase SQL Anywhere 12.0 ; SQL Anywhere 9.0 ; Sybase SQL Anywhere 10.0 ; Sybase SQL Anywhere 11.0

Keywords

SQL Anywhere out of range SQLA dateadd DATEADD DateAdd , KBA , BC-SYB-SQA-SRV , SQL Anywhere - Server , 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.