Many times the Unix Epoch Time gets stored in the database. But this is not very human readable and conversion is required for reports and dashboards.
Example of Unix Epoch Time:
Presto provides many date time functions to help with conversion.
How to Convert Epoch Time to Date in SQL?
In case of a Unix Epoch Time, the from_unixtime function can be used to convert the Epoch time. After converting the Unix Epoch time to a timestamp, you can cast it into other formats as needed such as extracting just the date. Examples follow below.
The from_unixtime function returns a timestamp.
from_unixtime(unixtime) → timestamp
Returns the UNIX timestamp
unixtime as a timestamp.
select from_unixtime(1529853245) as timestamp;
select cast(from_unixtime(1529853245) as date) as date;
More examples and information can be found here: https://ahana.io/answers/how-to-convert-date-string-to-date-format-in-presto/