How to convert a date to format ddmmyy NOT ddmmyyyy

Question

I am struggling to convert a date to format ddmmyy NOT ddmmyyyy.

The convert function allows all sorts of clever formatting but nothing close enough to fix using REPLACE.

Any help would be appreciated.

Answer 1

dd/mm/yy is British\French standard, so try this:

SELECT REPLACE(CONVERT(CHAR(8), [MyDateTime], 3), '/', '')

Answer 2

SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 5),'-','') 

format number 5 will do dd-mm-yy and then you can remove the -'s