Abby
Member since Oct 18, 2011
- Profile: /members/9136-abby.htm
- Comments: 1
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 »