Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at the jQuery Conference 2009 (Cambridge, MA) with: Bob Bonifield

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 »