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


Member since May 24, 2010

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 stored full length time stamp t... read more »