Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at the New York ColdFusion User Group (Feb. 2008) with: Clark Valberg and Ray Camden and Judith Dinowitz
Ben Nadel at the New York ColdFusion User Group (Feb. 2008) with: Clark Valberg@clarkvalberg ) , Ray Camden@cfjedimaster ) , and Judith Dinowitz

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 »