Just keeping it handy !
declare @StartTime as DateTime
set @StartTime= dateadd(dd,0, datediff(dd,0,'2011-06-08 11:18:26.000'))
select @StartTime as StartTime
Friday, June 17, 2011
Date Conversion from YYYY-MM-DD HH:MM:SS:MMM to YYYY-MM-DD 00:00:00:000 !
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment
I love to entertain onymous user Comment !