Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at cf.Objective() 2013 (Bloomington, MN) with:

anony-mouse

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 »