Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFinNC 2009 (Raleigh, North Carolina) with: Simon Free and Todd Sharp and Shannon Hicks and Charlie Arehart and Sean Corfield and Jason Dean
Ben Nadel at CFinNC 2009 (Raleigh, North Carolina) with: Simon Free@simonfree ) , Todd Sharp@cfsilence ) , Shannon Hicks@iotashan ) , Charlie Arehart@carehart ) , Sean Corfield@seancorfield ) , and Jason Dean@JasonPDean )

Niall Gallagher

Member since Jun 9, 2009

Recent Blog Comments By Niall Gallagher

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Jun 9, 2009 at 10:12 AM

    I'd recommend avoid strings entirely. select month(cast(convert(varchar,getdate(),105) AS datetime)), month(cast(convert(varchar,getdate(),101) AS datetime)) In my UK locale this returns 9 and 6 for the month values -- i.e. the month() function returns an incorrect value because the code converted... read more »