How to Convert this date 2022-11-06 to 06 - Nov - 22 in Sql Query

Hello Paul,

Please try the below SQL Statement to get the expected result.

DECLARE @Orignaldate DATETIME = '2022-11-06'
SELECT FORMAT (@Orignaldate, 'dd-MMM-yy') as FormattedDate

Note: Above Query will start support from SQL Server 2012.

Thanks

Vishal