Format Date into Day Name i.e. Mon, Tue, Wed etc...

[Philippa]

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

[David Portas]

SELECT DATENAME(DW,datetimecol)
FROM Sometable

--
David Portas
------------
Please reply only to the newsgroup
--

"Philippa" <ph*************@systemc.com> wrote in message
news:9c**************************@posting.google.c om...

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

[Philippa]

Thank you, this works like a dream

"David Portas" <RE****************************@acm.org> wrote in message news:<7O********************@giganews.com>...

SELECT DATENAME(DW,datetimecol)
FROM Sometable

--
David Portas
------------
Please reply only to the newsgroup
--

"Philippa" <ph*************@systemc.com> wrote in message
news:9c**************************@posting.google.c om...

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