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.
SAP Knowledge Base Article - Preview