Brian Young
Member since Jan 18, 2010
- Profile: /members/5207-brian-young.htm
- Comments: 1
Recent Blog Comments By Brian Young
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Jan 18, 2010 at 2:49 PM
i think a few people were close but made a slight mistake using the datediff methods. I use a DATEADD and DATEDIFF a lot and it's always worked perfectly for me DATEADD(dd, DATEDIFF(dd,0,GETDATE()), 0) Hope that helps!... read more »