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 CFUNITED 2009 (Lansdowne, VA) with:

Nick Kleinjan

Member since Mar 10, 2011

Recent Blog Comments By Nick Kleinjan

  • Ask Ben: Selecting Parts of a Date/Time Stamp In SQL

    Posted on Mar 10, 2011 at 4:18 PM

    This probably isn't the most elegant way to get a 2 digit formatted month in sql, but I've used something like this in the past. Convert the date to a string, then pull out the parts you need as a substring. Select SubString(Convert(Char(10), GetDate(), 102), 6, 2)... read more »