Community Member Profile
T. Phaneuf
Member since Dec 11, 2008
- Profile: /members/2270-T-Phaneuf.htm
- Comments: 1
- Points: 1
Recent Blog Comments By T. Phaneuf
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Feb 6, 2008 at 11:34 PM
To strip time off of datetime values to store only the day, I usually just use this approach declare @DateValue datetime set @DateTest = getutcdate() select convert(datetime, convert(int, @DateTest)) - or - convert(datetime, convert(int, <DateColumn>)) To st... read more »
