AnsweredAssumed Answered

DateTime conversion of exported CSV file type 1549663223992.0

Question asked by omid_1 on Apr 10, 2019
Latest reply on Apr 11, 2019 by EPolle_TensingInternational

I've got an automated process started that downloads a Feature Layer Collection from an AGOL account for clean-up and rewrite.  Comes down just fine as a CSV but the dates come down as a large number that I can convert using float.  I'm unable to come across any way to convert this in Python (3.7) to make it a usable DateTime feature.  Can you point me towards a way to accomplish this.  Neither of the lines of code below do anything with the number.

 

ndt_value = (datetime.datetime(float(date_value), dateFormat=u'%m/%d/%Y', timeFormat=u'%I:%M:%S %p')
ndt_value = time.strptime(float(date_value), "%d %b %y") 

 

They all come across looking like this.

            dte1                          dte2

value 1549492620000.0 1549663223992.0

value 1549493100000.0 1549661829963.0

value 1549493220000.0 1554867569006.0

value 1549394280000.0 1554867776915.0

Outcomes