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:

Estteban

Member since May 4, 2010

Recent Blog Comments By Estteban

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

    Posted on May 6, 2010 at 2:28 PM

    @TBonzai, Thank you, it work but I also need the date to be variable, I am currently using two querys with different times.: where my_datetime_column between DATEADD(hour, 4, DATEDIFF(DAY, 0, current_TIMESTAMP)) and DATEADD(minute, 870, DATEDIFF(DAY, 0, current_TIMESTAMP))... read more »

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

    Posted on May 4, 2010 at 9:44 AM

    In a table with thousands of records,one column being datetime, how can I divide the day in to 2 sections? Lets say 2 shifts. 1st shift starting at 04:00 and ending at 15:30, second shift starting at 15:30 and ending at 04:00. anyone has a suggestion for this? Thank you all.... read more »