SQL SERVER Difference Between GETDATE and SYSDATETIME
Posted
on Dot net Slackers
See other posts from Dot net Slackers
Published on Thu, 10 Jun 2010 00:00:00 GMT
Indexed on
2010/06/10
2:53 UTC
Read the original article
Hit count: 245
Filed under:
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 [...]...
Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
© Dot net Slackers or respective owner
