tags:

views:

30

answers:

2

i want to know the query so that i can get the name of today`s day

+3  A: 
select datename(dw,getdate())
Ed Harper
Which language (English, French, Klingon etc) does the returned name use?
belugabob
If you have Klingon as your database language you'd get that
Tommy
@belugabob - it will return in the language of your current connection, as shown by running `select @@language`
Ed Harper
My original comment was slightly tongue-in-cheek. I intended to highlight the fact that the answer wouldn't necessarily be in English. I'll be more specific next time.
belugabob
A: 

As well as the dw command mentioned by Ed, it will be worth you bookmarking DATENAME for future reference. (In the link, check the table right at the bottom of the page that lists all arguments, with example output)

kevchadders