Cloudera Community
VJM
user rank
New Contributor
My Accepted Solutions
Show All

Re: Impala - Convert bigint to timestamp

by New Contributor in Support Questions
‎05-31-2018 11:38 AM
1 Kudo
‎05-31-2018 11:38 AM
1 Kudo
Hi @AcharkiMed - Thanks for the response. But that query also returns NULL as the output.   But I got a resolution for the issue   select from_timestamp(CAST(CAST(s.conferencedatetime as decimal(30,0))/1000 AS timestamp), "yyyy-MM-dd HH:mm:ss.SSS") as starttime from session s ... View more

Impala - Convert bigint to timestamp

by New Contributor in Support Questions
‎05-08-2018 07:14 AM
‎05-08-2018 07:14 AM
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 -------------------------------- ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎06-04-2018 03:03 PM
Community Statistics
Member Since ‎05-08-2018 06:51 AM
Last Visited ‎06-04-2018 03:03 PM
Posts 2
Kudos received 1