Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Colleen Lanham and Demian Holmberg and Robert Dix and Paul Carney and Eric Pfleckl
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Colleen Lanham , Demian Holmberg@dah007 ) , Robert Dix@p_robert_dix ) , Paul Carney@perpetapaul ) , and Eric Pfleckl@epfleckl )

Chucky

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 »