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:

ExceptionalCase

Member since Aug 27, 2009

Recent Blog Comments By ExceptionalCase

  • Ask Ben: Comparing Only Times in SQL

    Posted on Aug 27, 2009 at 1:53 AM

    It doesn't work for some cases, try this example: declare @endTime datetime, @selectDate datetime set @selectDate = '2009-8-7' set @endTime = '2009-8-9 14:30:00' SET @endTime = CAST(cast(@selectDate as float) + (cast(@endTime as float) - FLOOR( CAST(@endTime AS FLOAT)))AS DATETIME) It returns '200... read more »