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
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.