Nick Kleinjan
Member since Mar 10, 2011
- Profile: /members/7964-nick-kleinjan.htm
- URL: http://www.pccontroltools.com
- Comments: 1
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 »