SELECT datename(weekday, my_date) + ", " +
       datename(month,   my_date) + " " + 
       datename(day,     my_date) + ", " +
       datename(year,    my_date)
FROM test004
GO