question convert unix timestamp to timestamp format in Archives of Support Questions (Read Only)

convert unix timestamp to timestamp format

itsdineshm — Fri, 02 Dec 2016 02:34:59 GMT

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

itsdineshm — Fri, 02 Dec 2016 06:24:22 GMT

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