I want to convert the unix time in HBase to timestamp. I tried to_date and to_timestamp.
The original unix time after convert_to is like "1434672665166", I have to use below to extract the correct timestamp. substr(to_timestamp(CAST(substr(CONVERT_FROM(T.log.ts,'UTF8'),1,10) AS INT)),1,19) Any better way? And does it consider the locale when convert time? When I use to_date, the 00:00:00 time will normally convert to previous day, is that because the locale? Thanks! George
