Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

convert unix timestamp to timestamp format

Solved Go to solution

convert unix timestamp to timestamp format

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

Accepted Solutions

Re: convert unix timestamp to timestamp format

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

1 REPLY 1

Re: convert unix timestamp to timestamp format

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

Don't have an account?
Coming from Hortonworks? Activate your account here