Difference between GETDATE and SYSDATETIME IN SQL SERVER
SELECT GETDATE() as ‘DATE’
SELECT SYSDATETIME() AS ‘DATE’
–NOTE : In CASE of GETDATE the precision is till milliseconds and in case of sysdatetime the precision is till nano seconds
Pawan Kumar
pawankkmr@hotmail.com