What is difference between GetDate and SysDateTime in Sql Server 2008 ?
Loading
What is difference between GetDate and SysDateTime in Sql Server 2008 ?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Aug 1, 2012, 12:05 AM
Hi,
The function GETDATE() returns the seconds part of the time in three fractions. The function SYSDATETIME() however returns the seconds part of the time in seven fractions.
The data type DATETIME2 stores dates and times in a higher precious than the (old) data type DATETIME and therefore the difference between GETDATE() and SYSDATETIME() is important when using DATETIME2.
Please refer
http://blog.sqlauthority.com/2010/06/10/sql-server-difference-between-getdate-and-sysdatetime/
hope this will help you.
Pradip PandeyPosted Jul 31, 2012, 11:24 PM
Both the function returns almost same result but one difference between these two and i.e. milliseconds & nanoseconds. When you use GETDATE() the precision is till milliseconds but in case of SYSDATETIME() it is nanoseconds.