Posted by aling on 12/18/06 12:48

Execute following T-SQL within Queary Analyzer of SQL Server 2000:

=======================================
DECLARE @dTest DATETIME

SET @dTest='2001-1-1 1:1:1:991'
SELECT @dTest

SET @dTest='2001-1-1 1:1:1:997'
SELECT @dTest

SET @dTest='2001-1-1 1:1:1:999'
SELECT @dTest
=======================================

You get what?
This is my result which is weird:

2001-01-01 01:01:01.990
2001-01-01 01:01:01.997
2001-01-01 01:01:02.000

Then what's the reason of this weird problem?

• Next in forum: Re: Performance Difference between SQL Server 2005 Standard Edition and Enterprise Edition
• Prev in forum: SQL 2005 Express with Advanced Services: missing providers
• Thread view: Weird millisecond part of datetime data in SQL Server 2000

[Reply to this message]