Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Ray Camden and Liz Frederick
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Ray Camden@cfjedimaster ) and Liz Frederick@lizign )

Phil Morris

Member since Nov 21, 2011

Recent Blog Comments By Phil Morris

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

    Posted on Nov 21, 2011 at 4:28 AM

    I like the floor() one personally, but the one that sticks in my brain for some odd reason (mainly cos it just works) is this one: select convert(datetime,convert(varchar(10),getdate(),120),120) today You can also change the varchar(10) to the length in the ISO date format 120 to the portion y... read more »