Check out DATENAME in BooksOnLine.
Andrew J. Kelly
SQL Server MVP
"anson" <aeze616cse.unsw.edu.au> wrote in message
news:cb7ba330.0306301619.3e082412posting.google.c om...> Dear sir,
> How do you retrieve the day of the week from the datetime value? I
> don't want the number. But I want like, 'Monday', 'Tuesday' and so on.
> Is it possible?