How do we get Current Months First Day?

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

SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(getDate())-1),getDate()),101)


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response