format

left(format (v.vorgangsdatum,'ddMMyyyy'),12) as Datum 

_______________________________________

 left(format (v.vorgangsdatum,'yyyy_MM_dd'),12) as Datum2

_______________________________________