Pages

Wednesday, September 4, 2013

SQL SERVER – Difference Between GETDATE and SYSDATETIME | Journey to SQL Authority with Pinal Dave

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. SELECT GETDATE() fn_GetDate, SYSDATETIME() fn_SysDateTime In case of GETDATE the precision is till miliseconds and in case of SYSDATETIME the precision is till nanoseconds. Now the questions is… Continue Reading...

Source: SQL SERVER – Difference Between GETDATE and SYSDATETIME | Journey to SQL Authority with Pinal Dave