Member since
12-01-2016
2
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
6630 | 12-01-2016 10:24 PM |
12-01-2016
10:24 PM
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 more
12-01-2016
06:34 PM
what is the sql query to convert unix timestamp in a column of table to julian or greg date format ?
... View more