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

Dedric Mauriac

Member since Apr 22, 2010

Recent Blog Comments By Dedric Mauriac

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

    Posted on Apr 22, 2010 at 1:43 PM

    For anyone attempting to get the end of the day as well (11:59 PM), just add a fraction to it. Make sure it has 8 nines to get to the max millisecond before midnight. print cast(0.99999999 + floor(cast( getdate() as float )) as datetime) I mainly needed it to use for "date between @start and @end"... read more »