convert unix timestamp to timestamp format

[#1]

what is the sql query to convert unix timestamp in a column of table to julian or greg date format ?

[#2 · Accepted solution]

Got figured it out, below query will convert the unix time to timestamp

select from_unixtime(cast(time/1000 as bigint)) from table_1;

time is the column name