Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

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 »