ict.ken.be

Delivering solid user friendly software solutions since the dawn of time.

GETDATE vs SYSDATETIME

Categories: SQL Server

The precision of SYSDATETIME is in nanoseconds, the one for GETDATE is in miliseconds.

Just try for yourself

SELECT SYSDATETIME() fn_SysDateTime, GETDATE() fn_GetDate