We have a field, where the timestamp is in "dd.mm.yyyy hh:nn:ss", i.e. "18.08.2019 12:22:50".

is there a better way to convert this to a timestamp than that i use at the moment:

cast(substring(myvarcharfield,7,4)+'-'+substring(myvarcharfield,4,2)+'-'+substring(myvarcharfield,1,2)+' '+substring(myvarcharfield,12,8) as timestamp)
--
Yusuf Zorlu
MicrotronX

Wow, sorry, but now i have found a better way with cast i have not seen before:

cast(oestatustext2 as timestamp DATE FORMAT 'DD.MM.YYYY'),

So this seems to be the best way,
--
Yusuf Zorlu
MicrotronX