Community Member Profile
Dimonytch
Member since Dec 11, 2008
- Profile: /members/2527-Dimonytch.htm
- Comments: 1
- Points: 1
Recent Blog Comments By Dimonytch
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Feb 27, 2007 at 2:14 PM
Landon, you can solve your problem with the nested select: select * from (SELECT reportdate,worktype, maintby, CAST( FLOOR( CAST( getDate() AS FLOAT ) ) AS DATETIME )as timeret, CONVERT(nvarchar(20), GETDATE(), 102) AS JustTheDate, CONVERT(nvarcha... read more »
