Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

convert unix timestamp to timestamp format

avatar
New Contributor

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

1 ACCEPTED SOLUTION

avatar
New Contributor

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

View solution in original post

1 REPLY 1

avatar
New Contributor

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