Error message with the Format Function

5

You can get this using:

Select concat(left(datename(month, su.updatedate), 3), '-', right(datename(year, su.updatedate), 2))

Or - if CONCAT doesn't work because of a version issue:

Select left(datename(month, su.updatedate), 3) + '-' + right(datename(year, su.updatedate), 2)