Datetime seconds are rounded up in case it has 999 milliseconds

Question

Hi,

I use SqlCE 3.5 and found interesting behavior. All Datetime value which has 999 milliseconds are rounded up. Any clue why? (998 ms is fine)

CREATE TABLE Test(  
 [CompleteTime] datetime NOT NULL
)
GO
INSERT INTO Test SELECT '2009-04-03 15:41:27.999'
GO
SELECT * FROM Test
GO
DROP TABLE Test

SqlCE 4.0 has same behavior.

Answer 1

Hello,

That's quite normal and well documented, see Data Types => datetime

datetime stores only .000, .003 and .007 values, all others are rounded.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing