Community Member Profile
Healthcare
Member since Oct 22, 2009
- Profile: /members/4594-Healthcare.htm
- Comments: 1
- Points: 9
Recent Blog Comments By Healthcare
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Oct 22, 2009 at 10:16 PM
I used the CAST( FLOOR( CAST( getDate() AS FLOAT ) ) AS DATETIME ) method. The architect of my company said it is too complex. He wanted to use CONVERT(varchar, GETDATE(), 101) so that every people will understand.... read more »
