Community Member Profile
X
Member since Dec 11, 2008
- Profile: /members/1489-X.htm
- Comments: 1
- Points: 1
Recent Blog Comments By X
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Aug 11, 2006 at 11:01 AM
The best way to go about this problem in MSSQL is CAST(DATEADD(DAY,0,GETDATE()) AS DATETIME) Actually, what we want to do is THE_DATE BINARYAND FFFFFFFF00000000... read more »
