SAP Knowledge Base Article - Preview

3468430 - The getdate() function returns a smaller value than a previous call - SAP ASE

Symptom

The getdate() function returns a smaller value than a previous call 

Example

The rows are being inserted into the table in the order of "delete" and "insert".
But, the getdate() on 2st row(Type : insert) is smaller than 1nd row(Type : delete).
In this case, the bigdatetime() values are right.

 type       spid        getdate()                      bigdatetime() 
 ---------- ----------- ------------------------------ -----------------------------
 delete              30 Apr 17 2024 15:08:29.103000    Apr 17 2024 15:08:29.103000  
 insert              30 Apr 17 2024 15:08:29.100000    Apr 17 2024 15:08:29.106000  


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise all versions

Keywords

CR829340, CR#829340, getdate, incorrect, time, datetime, correct,  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.