Community Member Profile
Cbu
Member since Jan 26, 2011
- Profile: /members/7676-Cbu.htm
- Comments: 1
- Points: 11
Recent Blog Comments By Cbu
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Jan 26, 2011 at 10:38 AM
DATEADD(d, 0, DATEDIFF(d, 0, @MyDate)) ------------------------------------- ^^^^ works perfectly. Tested SQL2008.... read more »
