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


Comments

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))

Output:Saturday

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

bye



  • 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:
    Email: