Reply
VJM
New Contributor
Posts: 1
Registered: ‎05-08-2018

Impala - Convert bigint to timestamp

I've a table called "session" and it has a column 'conferencedatetime' with datatype as 'bigint'

 

I want to get the output of this column in a date/timestamp format (for e.g. 2018-01-01 01:00:00)  

 

But I'm not able to get the desired output when I tried with the 'from_unixtime' function. (it returns NULL as output)

 

Can you please advise what is the correct way to get the output ?

 

---------------------
select s.conferencedatetime as starttime from session s ;
1500778867943

 

select from_unixtime(s.conferencedatetime, "yyyy-MM-dd HH:mm:ss") as starttime from session s ;
NULL
--------------------------------

Announcements