What is EOMonth function in Denali? Explain with example.

 Posted by Niladri.Biswas on 7/13/2012 | Category: Sql Server Interview questions | Views: 1349 | Points: 40
Answer:

This function is use to find out the last day of the month.
e.g.
Select LastDayOfcurrentMonth = CONVERT(varchar(10),EOMonth(GETDATE()),110)

/*
LastDayOfcurrentMonth
---------------------------------
07-31-2012
*/


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response