Community Member Profile
Dedric Mauriac
Member since Apr 22, 2010
- Profile: /members/5882-Dedric-Mauriac.htm
- URL: http://dedricmauriac.wordpress.com/
- Comments: 1
- Points: 11
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 @st... read more »
