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


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 »