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() 2011 (Minneapolis, MN) with:

Dedric Mauriac

Member since Apr 22, 2010

Recent Blog Comments By Dedric Mauriac

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Apr 22, 2010 at 1:43 PM

    For anyone attempting to get the end of the day as well (11:59 PM), just add a fraction to it. Make sure it has 8 nines to get to the max millisecond before midnight. print cast(0.99999999 + floor(cast( getdate() as float )) as datetime) I mainly needed it to use for "date between @start and @end"... read more »