Hi,
I'm using a JSON reader to grab data from an API. It's reading the attributes, but the datetime is formatted like so:
1587896100000
Firstly, what is the format of this? Is it JSON specific? And how can I convert to this to a SQL datetime,. which is where the output is going to be stored?
Thanks
N
It's epoch time (seconds since 1st Jan 1970 or in this case milliseconds), if you divide the value by 1000 to get seconds from milliseconds you can then use an input value of %s in the DateTimeConverter to convert it
It's epoch time (seconds since 1st Jan 1970 or in this case milliseconds), if you divide the value by 1000 to get seconds from milliseconds you can then use an input value of %s in the DateTimeConverter to convert it
Thank you!