Get time from datetime

[reporting_neu]

Hello,

I have a field with date, time and something I can't define: "2021-01-02 17:35:59.964+01:00"

I'd like to have the date and time and just the time out of it for once. I've tried all the formulas of the community, but I'm not successful. I always get null values ​​as a result. I can use the load script or expression.

I need: DD.MM.YY hh:mm

and: hh:mm

Who can help me?

[hic · Accepted solution]

TimeStamp(TimeStamp#(Left(DateTime,23),'YYYY-MM-DD hh:mm:ss[.fff]'),'DD.MM.YY hh:mm') as TimeStamp,
Time(TimeStamp#(Left(DateTime,23),'YYYY-MM-DD hh:mm:ss[.fff]'),'hh:mm') as Time,

[reporting_neu]

Thank you very much. I didn't think to shorten the characters. Very good idea!