求一简单SQL语句！

Question

求一SQL语句 输入日期 可以直接得到当前星期几
比如我输入2008-5-14,返回星期三。求达人指点！

Answer 1

select datename(weekday,getdate()) --> 星期三

Answer 2

SELECT datename(weekday,'2008-5-14')

Answer 3

--trycreate function f_datetoweek(@date datetime)
returns varchar(20)
as
begin
  declare @str varchar(20)
  select @str=datename(weekday,@date)
  return @str
endgoselect dbo.f_datetoweek('2008-05-14') 'result'
---result
   星期三
drop function f_datetoweek

Answer 4

select datename(weekday,getdate())

Answer 5

select datename(weekday,getdate())

Answer 6

SELECT DATENAME(dw, GETDATE())

Answer 7

select datename(weekday,getdate()) as weekday

Answer 8

select datename(weekday,getdate())

Answer 9

SQL codeSELECT DATENAME(dw, GETDATE())

Answer 10

select datename(weekday,getdate()) --> 星期三

Answer 11

select datename(weekday,getdate())
不过返回的结果是英文的

Answer 12

SET LANGUAGE  '简体中文'select datename(weekday,getdate())

Answer 13

SET LANGUAGE  '简体中文' 
SELECT datename(weekday,'2008-5-16') as 星期几