DATE IN sql

[robertrao]

Hello,

I have a SQL date '2016-01-31'.

How can i extract month and year together in TSQL,

Example: i WANT LIKE BELOW

01-2016

THANKS

[RW9]

Probably better to ask in a TSQL specific forum.  At a guess I would think cast:

https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql

[LinusH]

Why do want to use TSQL - assuming you have SAS and SAS/ACCESS at your disposal?