How do we get Current Months First Day?

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

Answer:

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

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : Why can't datareader by returned from a Web Servic ...

Next > : What is effort variance?

More Interview Questions by Nishithraj

Latest Interview Questions