i have following query


SELECT DISTINCT DATEADD(day, 0, DATEDIFF(day, 0, starttime)) as date FROM table

and these me return like this

2011-02-03 00:00:00.000


i want to convert that query that give reult like this

thursday ,feburay 2,2011

how to do this ??