HIVE SQL ISO timestamp. how to convert from string to numeric continuous?

Asked Jun 18 '21 at 18:29

Active Jun 19 '21 at 06:57

Viewed 107 times

So I have a timestamp column that is formatted as a string and looks like this:

2021-06-07T05:00:52.000000Z

Any advice on how I can get this converted to a normal numeric continuous timestamp?

How to deal with the "T" and the "Z"?

asked Jun 18 '21 at 18:29

surfer349

"timestamp column that is formatted as a string"?!? – jarlh Jun 18 '21 at 19:08
after converting to normal timestamp string you can apply unix_timestamp() to get seconds part as bigint – leftjoin Jun 19 '21 at 15:16

0 Answers0