Healthcare
Member since Oct 22, 2009
- Profile: /members/4594-healthcare.htm
- Comments: 1
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 »