What is the purpose of DATENAME fucntion?

 Posted by Nishithraj on 1/5/2010 | Category: Sql Server Interview questions | Views: 2129
Answer:

DATENAME returns the part of the date in a literal form.

Following is the example
SELECT DATENAME(mm,GETDATE())


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response