How to get the name of the day of date

That should be DATENAME(dw,'3 sep 2007')

But I prefer using fully qulified names DATENAME(weekday,'3 sep 2007')