Get Day Name

Get the day name from sql query,day name like sunday,monday,tuesday....etc

Get Day Name

hi friends

//you can use this sql statement to get day name of given date

select datename(dw,date) as dayname


Author: Narayana08 May 2010 Member Level: Gold   Points : 2

Hi shubhang,
Your query is working well,but it works on only mm/dd/yyyy format the following my query works on dd/mm/yyyy format see how:

Query: select datename(dw,convert(datetime,'08/05/2010',103))


Note:the convert() function converts mm/dd/yyyy to dd/mm/yyyy

Thanks for your coding also keep posting byee..

Author: shubhang sahai mathur11 May 2010 Member Level: Silver   Points : 1

hi Narayana,

thanks for your response you r right but i have also uploaded
the function to convert mm/dd/yyyy to dd/mm/yyyy format
keep checking in my resouces list you will find it

i will upload more concept about dates


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: