Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFinNC 2009 (Raleigh, North Carolina) with: Simon Free and Todd Sharp and Shannon Hicks and Charlie Arehart and Sean Corfield and Jason Dean
Ben Nadel at CFinNC 2009 (Raleigh, North Carolina) with: Simon Free@simonfree ) , Todd Sharp@cfsilence ) , Shannon Hicks@iotashan ) , Charlie Arehart@carehart ) , Sean Corfield@seancorfield ) , and Jason Dean@JasonPDean )

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 »