Sql report long for of day

1

Hi,
I want to display the long form of a day (eg ‘Saturday’ or ‘Sat’ on an SQL report.
I have tried :
DATE_FORMAT(tsd.from_time, ‘DY’),
DATE_FORMAT(tsd.from_time, ‘%W’),
but only get errors.
Does anyone know how to do this?
thanks.

2 
DAYNAME(tsd.from_time)

or

DATE_FORMAT(tsd.from_time, '%%W')
3

thanks worked a treat.