Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.


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 »