How to get current month only?

Posted by vishalneeraj-24503 on 12/27/2013 | Category: Sql Server Interview questions | Views: 3985 | 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

Bookmark It

< Previous : How to check whether Dropdownlist has any items or ...

Next > : How to set Textbox control to Readonly in Javascri ...

More Interview Questions by vishalneeraj-24503

Latest Interview Questions