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.
DAYNAME(tsd.from_time)
or
DATE_FORMAT(tsd.from_time, '%%W')
thanks worked a treat.