How to get current month only?

 Posted by vishalneeraj-24503 on 12/27/2013 | Category: Sql Server Interview questions | Views: 2548 | Points: 40
Answer:

With the help of Month in-built sql-server functions,we can get current month. It will return Month in numeric as 1 to 12

For Example:-

select month(getdate()) as 'current month';


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response