Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at Ellen's Stardust Diner (New York City) with: Colin Silverberg and Carol Loffelmann and Daniel Silverberg
Ben Nadel at Ellen's Stardust Diner (New York City) with: Colin Silverberg , Carol Loffelmann ( @Mommy_md ) , and Daniel Silverberg

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 »