Community Member Profile
Chucky
Member since May 24, 2010
- Profile: /members/6097-Chucky.htm
- Comments: 1
- Points: 12
Recent Blog Comments By Chucky
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on May 24, 2010 at 2:27 PM
All, I'm a newbie and I'm trying to move a date function from MySQL to SQL Svr 2008. In MySQL it looks like: begin RETURN cast(concat(year(thisDate),right(concat('00', month(thisDate)),2)) as unsigned int); end Return Type: int(11) The end result is to convert a sto... read more »
