Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2013 (Bloomington, MN) with: Elliott Sprehn and Chris Phillips and Nathan Strutz and Anant Pradhan and Dave DeVol and Byron Raines and Gerry Gurevich
Ben Nadel at cf.Objective() 2013 (Bloomington, MN) with: Elliott Sprehn@ElliottZ ) , Chris Phillips@cfchris ) , Nathan Strutz@nathanstrutz ) , Anant Pradhan@blitheutopian ) , Dave DeVol , Byron Raines ( @byronraines ) , and Gerry Gurevich

APeterson

Member since Dec 11, 2008

Recent Blog Comments By APeterson

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

    Posted on Sep 20, 2007 at 9:24 PM

    yikes, use this, and drop all that cast and floor stuff. create function DateOnly(@DateTime DateTime) -- Returns @DateTime at midnight; i.e., it removes the time portion of a DateTime value. returns datetime as begin return dateadd(dd,0, datediff(dd,0,@DateTime)) end go reference: h... read more »