Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.


Member since Dec 11, 2008

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 »