How can i select a datetime as ddMMyy, so a two-digit year?

Question

I'm replacing my C# code for performance reasons with a sql query:

CreatedAt.ToString("ddMMyy", System.Globalization.CultureInfo.InvariantCulture)

returns the creation-date as 140115(for today). Simple enough in C#, but how do i get this in T-SQL?

I have tried:

REPLACE(CONVERT(CHAR(10), ChargeArrival.CreatedAt, 103), '/', '')

which is almost correctly, but the year has four digits instead of two, so 14012015 instead of 140115.

Answer 1

As the docs for CONVERT state, use 103 if you want the century and 3 if you dont:

REPLACE(CONVERT(CHAR(10), ChargeArrival.CreatedAt, 3), '/', '')