only month and year from date:

SELECT CONVERT(CHAR(4), yourdatecolumn, 100) + CONVERT(CHAR(4), yourdatecolumn, 120)FROMyourtablename

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

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email