SQL Server - How to Get Only Month and Year From Date

Introduction:

Here I will explain how to get only month and year from date in sql server or extract only month and year from date time field in sql server.

Description:

In previous articles I explained get time difference between two dates in sql, sql datediff function to show date difference in days, difference between function and stored procedures, joins in SQL Server, substring function in SQL server and many articles relating to SQL server. Now I will explain how to get only month and year from date in sql server.

To get only month and year from date in sql server we need to write the query like this

SELECT CONVERT(CHAR(4), yourdatecolumn, 100) + CONVERT(CHAR(4), yourdatecolumn, 120)FROM yourtablename

Example

SELECT CONVERT(CHAR(4), getdate(), 100) + CONVERT(CHAR(4), getdate(), 120)

Once we run above query we will get output like as shown below

Output

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email