Convert date-type to char with custom format-mask

Hi  together.
I have a select-statement against a bi server source.

I want to select a date column and change it to char with a custom format-mask (like.: dd.mm.yyyy).

My select statement looks like:

select    cast ("Zeit"."Datum" as char(10))  as "Datum"
 from     "BI STM"."Zeit" "Zeit"
order by "Zeit"."Datum" ASC

But how can i change the format-mask that you want to get back?

(Passing date to the rtf-template is no solution for me, because i don't want to handle with timezones)


Regards Christian