It seems that this would work:

update <table>

set BuchungZeit = cast(<col> as datetime)

where IsDate(<col>) = 1

You are checking the first 9 characters of <col> in your where clause, yet you aren't...