Apr 16 2023
SELECT DATEDIFF(millisecond, GETDATE(), GETDATE())
SELECT DATEDIFF(millisecond, GETDATE(), CURRENT_TIMESTAMP)
Can I get a number greater than 0 millisecond?
Apr 17 2023
@vuvcpg , what on earth do you expect here for a result different the 0 milliseconds? The function GETDATE() is evaluated at once, so the query can't ever return something different the 0 ms.