Home Forums SQL Server 2005 T-SQL (SS2K5) getdate() accuracy RE: getdate() accuracy
Scalability Doug
SSCertifiable
Points: 5351
More actions
May 15, 2008 at 8:00 am
#815889
Look at BOL: "datetime values are rounded to increments of .000, .003, or .007 seconds, as shown in the following table."
If you need that extra precision, look into upgrading to SQL 2008 and using the DATETIME2 and TIME data types.
DAB