Today i will tell you how to retrieve month from date using Sql.
In the Previous articles i explained where to place google analytics tracking code, how to retrieve day from date using C#.net, how to retrieve month from date in c#.net, how to retrieve year from date in c#.net, how to retrieve day from date in sql and many more about Sql.
Today or in future you will have to get month from date using sql.
SELECT Month('2/4/2014') AS [date_month]
Here what we are doing is getting month from current date of server.
Suppose you want to get date from table then use below query.
SELECT Month(date_column) AS [date_month] FROM Table_name