PostGre SQL Timestamp and Duration Format not readable

[Krzysztof_Hyla]

Hi, I'm pulling some data (our warehouse forklifts usage metrics) from PostGre SQL database having no previous experience with epoch date & time formats.

Can someone tell me how to convert following columns into human readable data either with SQL or with Power Query transformations? Especially "Unix Hour Begin" and "Duration" columns.

Here is what I'm pulling in Power Query using PostGreSQL connector and SQL statement:

Here is how it looks like in the database:

[Krzysztof_Hyla]

Awesome! Thanks a ton, it's really working. 

Any idea how to do the same in sql code?

[lbendlin]

something along these lines

sql - PostgreSQL: how to convert from Unix epoch to date? - Stack Overflow

[lbendlin · Accepted solution]

You can convert from Unix Hour Begin to a regular date with 

#datetimezone(1970,1,1,0,0,0,0,0)+#duration(0,[Unix Hour Begin],0,0)

(this is based on UTC, so you then need to convert into local time).