select stuff(stuff(convert(varchar(11), getdate(), 111), 5, 1, ‘-‘), 8,
1, ‘-‘)

Neat!