DATE IN sql - SAS Support Communities

Quartz | Level 8

Quartz | Level 8

DATE IN sql

Posted 06-13-2017 05:10 AM (689 views)

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

2 REPLIES 2

Diamond | Level 26

Diamond | Level 26

Re: DATE IN sql

Posted 06-13-2017 05:23 AM (682 views) | In reply to robertrao

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

Tourmaline | Level 20

Tourmaline | Level 20

Re: DATE IN sql

Posted 06-14-2017 11:30 AM (659 views) | In reply to robertrao

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

Data never sleeps