Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Matthew Abbott and Andrew Abbott and Chuck Leverette
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Matthew Abbott@abbottmw ) , Andrew Abbott , and Chuck Leverette

Rem

Member since Dec 11, 2008

Recent Blog Comments By Rem

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

    Posted on Jun 3, 2008 at 8:01 AM

    WOW - That's the slickest version yet I always used to use the CONVERT(SmallDateTime, FLOOR(CAST(@dtDate as float)), 103) method The CAST as INT would also work (because of the FLOOR() function) but your DateAdd / DateDiff method not only runs quick, is fully Deterministic, can work with both dat... read more »