topic DateTime conversion of exported CSV file type 1549663223992.0 in Admin Tools Questions

DateTime conversion of exported CSV file type 1549663223992.0

JackieFisher — Wed, 10 Apr 2019 22:05:22 GMT

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

Re: DateTime conversion of exported CSV file type 1549663223992.0

Egge-Jan_Pollé — Sun, 12 Dec 2021 09:00:51 GMT

Hi Jackie Fisher‌,

The date values in your output are epoch timestamps in milliseconds.

The time.ctime() function takes seconds passed since epoch as an argument and returns a string representing local time. So, you have to divide your values by thousand, like this:

import time

print(time.ctime(1549492620000.0/1000))

# Output will be:
# Wed Feb 06 23:37:00 2019‍‍‍‍‍‍

For a quick, manual conversion of an epoch timestamp you can have a look at this website: https://www.epochconverter.com/

HTH,

Egge-Jan

Re: DateTime conversion of exported CSV file type 1549663223992.0

JackieFisher — Thu, 11 Apr 2019 17:38:27 GMT

Thank You. It was just driving me crazy.

Re: DateTime conversion of exported CSV file type 1549663223992.0

Egge-Jan_Pollé — Thu, 11 Apr 2019 17:55:31 GMT

Please feel free to mark the answer as correct if your issue is being solved 🙂