Get Year Month two digit format SQL SERVER
Get Year Month two digit format
Need to convert the date to get the month value in two digit format and then we need to concatenate to display as a single value.
select convert(nvarchar,YEAR(GETDATE())) + SUBSTRING(CONVERT(nvarchar,getdate(), 112),5,2)
Get Year and Month in two digit format in SQL SERVER was last modified: October 1st, 2017 by