Is there a conversion for a date field in SQL to show the day of the
week that day is ? I've looked in help with no luck. I know in excel
for example you can create custom format for a date to 'dddd' and it
displays the Monday, Tuesday etc... Even it the Day number was
returned i.e if Monday = 1 then 1, 2, 3, 4, 5, 6, 7 instead of day
names.
Philippa