Community Member Profile
Rem
Member since Dec 11, 2008
- Profile: /members/1189-Rem.htm
- Comments: 1
- Points: 1
Recent Blog Comments By Rem
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Jun 3, 2008 at 8:01 AM
WOW - That's the slickest version yet I always used to use the CONVERT(SmallDateTime, FLOOR(CAST(@dtDate as float)), 103) method The CAST as INT would also work (because of the FLOOR() function) but your DateAdd / DateDiff method not only runs quick, is fully Deterministic, can... read more »
