Get week day

How can I get week day with SQL?
You can get the weekday of the current day with:
SELECT DATEPART(dw, GETDATE())
or
SELECT DATENAME(dw, GETDATE())
if you want the name.
Jacco Schalkwijk
SQL Server MVP
"David" <david_dvali@.hotmail.com> wrote in message
news:uMg7SLo5EHA.4072@.TK2MSFTNGP10.phx.gbl...
> How can I get week day with SQL?
>