Community Member Profile
Richard
Member since Feb 19, 2010
- Profile: /members/5485-Richard.htm
- Comments: 1
- Points: 9
Recent Blog Comments By Richard
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Feb 19, 2010 at 8:47 AM
Dmitry - I was always told it was bad practice to mix cast and convert.. not sure what people think. I've found that for 10k to 100k rows plus that the following is most performant. CONVERT(DATETIME, CONVERT(VARCHAR(12), GETDATE(), 113))... read more »
