Query results from query,json

1

Start and end times are in this format 1619568745111. How do i get a meaningful date from it?

2

These are epoch timestamps, you can easily convert them to human readable dates in your favorite language.

3

Thank you Doron. Found it. Just in case someone else needs it this is what i did
“TO_TIMESTAMP”(“start” / 1000.0) AS “startTime”, “TO_TIMESTAMP”(“finish” / 1000.0) AS “finishTime”, CAST(“totalDurationMS” / 60000.000 AS DECIMAL(10, 3)) AS “totalDurationMinutes”, CAST(“totalDurationMS” / 1000.000 AS DECIMAL(10, 3)) AS “totalDurationSeconds”, “totalDurationMS”