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

Dewald van Staden

Member since Sep 8, 2011

Recent Blog Comments By Dewald van Staden

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

    Posted on Sep 8, 2011 at 5:00 AM

    Hi Ben, Great blog, use it a lot. I am running SQL Server 2008R2 and I just go: CAST(GetDate() AS DATE) AND CAST(GetDate() as TIME) Am I missing an obvious benefit by Flooring the Float first? Or do you think the above will work just fine everywhere plus performance wise? Regards, Dewald... read more »