JSON's date format is rather strange. It is milliseconds since January 1st 1970, with a time zone tacked on the end.
There are snippets of Java code available if you look for them.
In ESQL, you could declare a constant GMTTIMESTAMP initialized to the epoch ( 1-1-1970 ) and then create an INTERVAL value from the JSON ( using hand-written ESQL ) and add the INTERVAL value to the constant TIMESTAMP. Then create and add another INTERVAL value for the time zone and you are done.
Who said it was supposed to be easy? _________________ Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum