SAP Knowledge Base Article - Preview

2333462 - COMNLIB:'select datename(cdw, getdate())' returns wrong day - SDK for SAP ASE

Symptom

When running select statement 'select datename(cdw, getdate())' the wrong day of the week is returned:

1> select datename (cdw, getdate())

 ------------------------------------------------------------
 Monday                               <==== this should be Wednesday


Read more...

Environment

  • SAP Sybase Software Developers Kit (SDK) 15.7 SP136
  • SAP Software Developers Kit (SDK) for Adaptive Server Enterprise (ASE) 16.0 SP01 PL02
  • SAP Software Developers Kit (SDK) for Adaptive Server Enterprise (ASE) 16.0 SP02 PL01

Product

SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7

Keywords

Software Developer Kit, SDK, ASE, Adaptive Server Enterprise, CR, change record, report, request, Bug, Open Client, OpenClient, ct-lib, ct-library, datetime, date, day of the week, function, getdate, calweekofyear, calyearofweek, caldayofweek, CR#783851, CR783851, 783851 , KBA , BC-SYB-SDK , SDK , Product Enhancement

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.