|
Home > Archive > microsoft.public.sqlserver.server > June 2002 > Formatting Date to Return 'Day of the week'
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Formatting Date to Return 'Day of the week'
|
|
|
| Dear All
I am using SQL2k on Win 2k, can anyone tell me how i format the date to
return the actual day it is.....
ie in Access you can use format("ddd",[datefield]) and it will return u the
date of the date field. is there something similar in SQL Server.
Many Thanks In Advance
ASH
| |
| Jasper Smith 2002-06-28, 9:25 am |
| select datename(weekday,datecolumn)
The number produced by the weekday datepart depends on the value
set by SET DATEFIRST, which sets the first day of the week
HTH
Jasper Smith
"Ash" <ash_khan100@hotmail.com> wrote in message
news:afhrnh$5gu$1@helle.btinternet.com...
> Dear All
>
> I am using SQL2k on Win 2k, can anyone tell me how i format the date to
> return the actual day it is.....
>
> ie in Access you can use format("ddd",[datefield]) and it will return u
the
> date of the date field. is there something similar in SQL Server.
>
> Many Thanks In Advance
>
> ASH
>
>
|
|
|
|
|