how to convert bigint to date ?

[jiangxy]

Is there a function can convert bigint to date ?

I store timestamp in memory and want to view as date(like yyyy-MM-dd ) when analysis heap.

Tried from_unixtime() but not work.

[Lerm]

Here is one way to convert timestamps to readable format:

select 
 d.this, 
 timestamp'1970-01-01 00:00:00.000' + interval (d.fastTime/1000) second as date_timestamp
from "java.util.Date" d