Sometime something so simple skips our mind. I never knew the difference between GETDATE and SYSDATETIME. I just ran simple query as following and realized the difference.
In case of GETDATE the precision is till miliseconds and in case of SYSDATETIME the precision is till nanoseconds
In case of GETDATE the precision is till miliseconds and in case of SYSDATETIME the precision is till nanoseconds
No comments:
Post a Comment