Formating date and times in T-SQL is not as hard as I originally thought

MySQL has some great date formatting features that I missed in T-SQL.

Turns out, T-SQL has some nice features too.

SELECT FORMAT( @d, 'dd/MM/yyyy', 'en-US' ) AS 'DateTime Result'

See https://msdn.microsoft.com/en-AU/library/hh213505.aspx