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


Member since Jul 19, 2011

Recent Blog Comments By Doug

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

    Posted on Jul 19, 2011 at 3:28 PM

    I've been searching the web for a while now and I can't find an answer... if i only need date from a datetime column with sql server 2008 is CAST(thedatetime AS DATE) or DATEADD(dd, DATEDIFF(dd,0,thedatetime), 0) more efficient? It seems like there's still a lot of old dogs swearing by dateadd/date... read more »