Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Brian Swartzfager and Simon Free and Jason Dean and Jim Priest and Vicky Ryder and Dan Wilson
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Brian Swartzfager@bcswartz ) , Simon Free@simonfree ) , Jason Dean@JasonPDean ) , Jim Priest@thecrumb ) , Vicky Ryder@fuzie ) , and Dan Wilson@DanWilson )

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 »