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

Report this post to a moderator

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
>
>

Report this post to a moderator