topic Re: Time stamp Conversion in App Development

Time stamp Conversion

Raju_6952 — Sat, 20 Apr 2024 16:43:29 GMT

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 — Sun, 21 Apr 2024 15:42:28 GMT

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 — Sun, 21 Apr 2024 15:14:24 GMT

Why Floor()?

-Rob

BrunPierre — Sun, 21 Apr 2024 15:48:18 GMT

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