Convert XML date/time to Oracle Date/Time format

[Prismo]

I have a date/time value in xml document that looks like this: \[quote\] 2012-02-29T00:00:00+01:00\[/quote\]I have to convert that date to oracle date in this format \[quote\] dd.MM.yyyy hh24:mi:ss\[/quote\]I tried like this: \[code\]string cre_date = "convert(to_date,'" + dr_art_apa["CreationDateTime"] + "', 'dd.MM.yyyy hh24:mi:ss')";\[/code\]But nothing, so help somebody!!!