Apr 16 2023 03:06 AM
eg:
SELECT DATEDIFF(millisecond, GETDATE(), GETDATE())
and
SELECT DATEDIFF(millisecond, GETDATE(), CURRENT_TIMESTAMP)
Can I get a number greater than 0 millisecond?
Apr 17 2023 03:37 AM
SELECT DATEDIFF(millisecond, GETDATE(), GETDATE())
@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.