Cloud Stack Ninja

I have a json file where all the dates in the json are in /Date(1602949450000)/

the json is also nested. is there a generic way to parse all of /Date()/ into the timestamp?

I tried regexp_replace but I cannot convert the capture group into a timestamp.

regexp_replace("value", "\\/Date\\((\\-?\\d*?)([\\+\\-]\\d*)?\\)\\/","$1")


Read more here: https://stackoverflow.com/questions/64404356/how-to-convert-dateepoch-time-string-in-pyspark

Content Attribution

This content was originally published by prideloki at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: