Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at BFusion / BFLEX 2009 (Bloomington, Indiana) with: Andy Matthews and Steve Withington and Rob Huddleston
Ben Nadel at BFusion / BFLEX 2009 (Bloomington, Indiana) with: Andy Matthews@commadelimited ) , Steve Withington@stevewithington ) , and Rob Huddleston

Will Godfrey

Member since May 3, 2013

Recent Blog Comments By Will Godfrey

  • Ask Ben: Comparing Only Times in SQL

    Posted on May 3, 2013 at 3:52 PM

    If you want to work with the time portion of a datetime as an integer, this simple snip gives you minutes since midnight: DATEDIFF(MINUTE, CAST(MyDate AS DATE), MyDate) So, if I want to capture records that are only dated during the day, I use: WHERE DATEDIFF(MINUTE, CAST(MyDate AS DATE), MyDate... read more »