SAP Knowledge Base Article - Preview

1339146 - "Syntax error during implicit conversion of VARCHAR value '07/02/2008 12:0:0 vorm' to a DATETIME field" with date object when using Sybase with German locale in Desktop Intelligence


  • "Syntax error during implicit conversion of VARCHAR value '07/02/2008 12:0:0 vorm.' to a DATETIME field"
  • When running a report on a Sybase database, the date format in the SQL is generated incorrectly if the locale in Desktop Intelligence (Tools > Options) are set to German.
  • The date format generated in the SQL is "dd/mm/yyyy hh:m:s vorm." instead of "dd/mm/yyyy hh:m:s am"
  • An error is generated when the report is run:

Exception: DBD, [Server DATASHOP_SERVER] [Procedure CTDynamic]
error during implicit conversion of VARCHAR value '07/02/2008 12:0:0                                                               
vorm.' to a DATETIME field.                                                                                                        
State: ZZZZZ      

  • When creating exactly the same report in WebIntelligence Rich Client, the SQL is correctly generated with "dd/mm/yyyy hh:m:s am" date-time format



SAP BusinessObjects Enterprise XI 3.1


Deski , KBA , BI-RA-DKI , Obsolete - Desktop Intelligence , Bug Filed

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.