AnsweredAssumed Answered

Dates not coming in correctly in python API

Question asked by burl_shahib on May 8, 2018
Latest reply on May 8, 2018 by rvburton

I am using the Python API in a Jupyter notebook to access a feature service in AGOL with the goal of turning it into a dataframe, run some analysis, and then export it to excel. Everything works fine except the date columns keep coming in as long integers (i.e. 1519249914451). I have attempted to change the columns datetype from int64 to a datetime64[ns] but the date always comes back as 1970-01-01 00:25:19.249914451. The date should be in 2018. 

 

Is there a different conversion that I should be using for this to get the correct date?

Outcomes