SQLServerLifer (5/15/2008)
The GETDATE() function returns a DATETIME type. Therefore it will inherit the same rounding limitation.
Yes, but it might add "Limitations" of its own. In particular (and what this discussion is really about), the internal speed or increment of the "clock" that SQL Server is using may be larger than 3.33ms. If fact, it may be 13 or 14ms.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]