Time stamp Conversion

[Raju_6952]

Hi ,

I have time stamp column as follows :2023-01-09 20:39:14.0000000 +00:00

how to convert this to regular format as 'DD/MM/YYYY h:mm:ss TT'.

Any Suggestions would be highly appreciated.

Thanks in Advance.

[BrunPierre]

Hi, try with this.

Timestamp((Timestamp#([Timestamp Column],'YYYY-MM-DD hh:mm:ss.fffffff +ff:ff')),'DD/MM/YYY h:mm:ss TT')

[rwunderlich]

Why Floor()?

-Rob

[BrunPierre · Accepted solution]

 Good catch, the output format was overlooked. Corrected now.