I think this code is about as short as it gets to do this:
select
[DD-MM-YYYY] =
convert(varchar(10),dateadd(mm,(12*YEAR_)-22801+MONTH_,DAY_-1),105),
[Date]=dateadd(mm,(12*YEAR_)-22801+MONTH_,DAY_-1),
a.*
from
PS_TestForOnline a
Results:
DD-MM-YYYY Date DAY_ MONTH_ YEAR_
---------- ----------------------- ----------- ----------- -----------
01-01-2012 2012-01-01 00:00:00.000 1 1 2012
01-02-2012 2012-02-01 00:00:00.000 1 2 2012
01-03-2012 2012-03-01 00:00:00.000 1 3 2012
(3 row(s) affected)
More info on this subject in this link: