https://communities.sas.com/t5/SAS-Procedures/DATE-IN-sql/m-p/367002#M64898 Why do want to use TSQL - assuming you have SAS and SAS/ACCESS at your disposal? Wed, 14 Jun 2017 15:30:07 GMT LinusH 2017-06-14T15:30:07Z https://communities.sas.com/t5/SAS-Procedures/DATE-IN-sql/m-p/366444#M64864 <P>Hello,</P><P>&nbsp;</P><P>I have a SQL date '2016-01-31'.</P><P>How can i extract month and year together in TSQL,</P><P>&nbsp;</P><P>Example: i WANT LIKE BELOW</P><P>&nbsp;</P><P>01-2016</P><P>&nbsp;</P><P>&nbsp;</P><P>THANKS</P> Tue, 13 Jun 2017 09:10:01 GMT https://communities.sas.com/t5/SAS-Procedures/DATE-IN-sql/m-p/366444#M64864 robertrao 2017-06-13T09:10:01Z https://communities.sas.com/t5/SAS-Procedures/DATE-IN-sql/m-p/366449#M64865 <P>Probably better to ask in a TSQL specific forum. &nbsp;At a guess I would think cast:</P> <P><A href="https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql" target="_blank">https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql</A></P> Tue, 13 Jun 2017 09:23:26 GMT https://communities.sas.com/t5/SAS-Procedures/DATE-IN-sql/m-p/366449#M64865 RW9 2017-06-13T09:23:26Z https://communities.sas.com/t5/SAS-Procedures/DATE-IN-sql/m-p/367002#M64898 Why do want to use TSQL - assuming you have SAS and SAS/ACCESS at your disposal? Wed, 14 Jun 2017 15:30:07 GMT https://communities.sas.com/t5/SAS-Procedures/DATE-IN-sql/m-p/367002#M64898 LinusH 2017-06-14T15:30:07Z