anony-mouse
Member since Dec 11, 2008
- Profile: /members/1234-anony-mouse.htm
- Comments: 1
Recent Blog Comments By anony-mouse
-
Careful When Trying To CAST DATETIME AS INT
Posted on Aug 30, 2007 at 5:07 PM
hmm... it doesn't truncate datetime, it rounds, I wonder if this is a bug? try this and see... SELECT CAST( 0.9999999999999 AS int ), CAST( 0.0000000000000001 AS int ) SELECT CAST( cast(0.9999999999999 as datetime) AS int ), CAST( cast(0.0000000000000001 as datetime) AS int )... read more »