Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at RIA Unleashed (Nov. 2009) with: Kimberly Morrow
Ben Nadel at RIA Unleashed (Nov. 2009) with: Kimberly Morrow@KimberlyMorrow )

Abby

Member since Oct 18, 2011

Recent Blog Comments By Abby

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

    Posted on Oct 18, 2011 at 10:41 AM

    Hi Ben, How can I select the entire date portion of a "dd/mm/yyyy hh:mm:ss AM/PM" date/time stamp? One catch is that the Len() function can't be used because sometimes the day, month, or any component of the time is one digit (i.e., no 'filler' zeros are used). I haven't been able to fi... read more »