Member since
07-21-2020
1
Post
0
Kudos Received
0
Solutions
08-10-2020
02:27 AM
Hi, I need to transform a string column into a timestamp with milliseconds . I tried several formats : select from_unixtime(unix_timestamp('2020.07.07 19:24:32.734000000','yyyy.MM.dd HH:mm:ssss'));
RESULT> 2020-07-07 19:24:32 select from_unixtime(unix_timestamp('2020.07.07 19:24:32.734000000','yyyy.MM.dd HH:mm:ss.SSS'));
RESULT> 2020-07-16 07:17:52 But it didn't work.
... View more
Labels:
- Labels:
-
Apache Hive