Hi,
There are lots of way available in SQL to get your requirement. I have done as below
SELECT CONVERT(VARCHAR(3),GETDATE(),107) + '-' + CONVERT(VARCHAR(2),GETDATE(),102)
Also refer below link
SQL Date Formats[
^]
Hope this will be helpful to you.
Cheers