Date Time format according to culture in MS SQL 2008 -

Date Time format according to culture in MS SQL 2008 -

this code converts datetime particular format i.e mm/dd/yyyy (culture:"en-us")

convert(varchar(max),getdate(),101)

i want convert datetime format depending on culture. example,

(1)date format of danish culture dd-mm-yyyy (da-dk)

(2)date format of german culture dd.mm.yyyy (de-de)

how can acheive in ms sql server 2008

in knowledge possible date , time per civilization defined, after sql server 2012 , above. below can accomplish making custom function per civilization homecoming date , time in required format.

sql-server-2008