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

Advertisements