Show Unix Timestamp as Datetime in PG2
Probably a simple question but i couldn't find the solution:
I get the DateTime (e.g. 05/02/2016 20:52:33) from the Controller in Integer format as seconds from 1970 (Unix timestamp).
How can i show this in human readable format to the User in PG2?
DateTime seems to require entry in "year, month, day, hour..." which is not available in my case, and i couldnt find a Function in PG2 to convert from a Unix Timestamp
Voted best answer
1
See the picture (the Datetime(1970,1,1) has been converted to a number).
Answers
0
I think you have to do it this way as Kdo describes it.
0
Its even simpler:
Datetime(UnixTimestamp) + Timestamp(1970,1,1)
Add new comment