KNOWLEDGE BASE

When Using the DATE Function on a Live Connection to SAP Sybase IQ, an Error Occurs


Published: 19 Dec 2017
Last Modified Date: 20 Dec 2017

Issue

When using the DATE function on a Live connection to SAP Sybase IQ, this error occurs:
 
throw DataSourceException (type=Unknown): [Sybase][ODBC Driver][Sybase IQ]Data exception - data type conversion is not possible. 
-- (dflib/dfe_Cast.cxx 840)

Environment

  • Tableau Desktop
  • Sybase IQ

Resolution

Ensure that the date held in the calculated field is in the format YY-MM-DD.

Cause

SAP Sybase IQ only understand DATE("YY-MM-DD")

If instead using:
 
DATE("MM-DD-YY")
or
DATE("DD-MM-YY")

Then, the error will appear.

Additional Information

  • Sybase Documentation: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1510/html/iqrefbb/X315936.htm
  • IBM Documentation: http://www-01.ibm.com/support/docview.wss?uid=swg21398016
Did this article resolve the issue?