topic Re: Arcgis datetime format python in Python Questions

Arcgis datetime format python

GarretVo — Wed, 13 Oct 2021 03:08:22 GMT

Hi all,

I use python to export my data into arcgis online. I am struggling with the time column. Every time I export, the time column is still registering as string. I am quite lost. Can anyone help? I would appreciate it. My code is below for one time instance is below:

time_data = datetime.datetime(2021, 4, 22, 12, 1)

time_reformat = datetime.datetime.strftime(time_data,'%Y/%m/%d %H:%M:%S')

The variable tim

Re: Arcgis datetime format python

GaryStaker1 — Wed, 13 Oct 2021 03:27:42 GMT

Your time_data variable is a datetime object and the time_reformat variable is a string object.

Is this not what you are expecting?

Re: Arcgis datetime format python

GarretVo — Wed, 13 Oct 2021 13:57:38 GMT

Hi Garry,

I expect the time_reformat variable is a string, but with the format as described the following link:

https://doc.arcgis.com/en/arcgis-online/manage-data/work-with-date-fields.htm

the time_reformat should become date type when the data is imported into ESRI. Can you please let me know what I got wrong?

Re: Arcgis datetime format python

BlakeTerhune — Wed, 13 Oct 2021 14:44:03 GMT

Are you importing the time_reformat value into a date field in Esri? In my experience, you can use the raw datetime object in a date field, no need to reformat it.

Re: Arcgis datetime format python

GarretVo — Wed, 13 Oct 2021 15:47:02 GMT

Yes I am. Correct me if I am wrong. Basically, I can put the variable time_data into date field without any issues. Can you please let me know? Thanks

Re: Arcgis datetime format python

BlakeTerhune — Wed, 13 Oct 2021 19:43:27 GMT

Correct. Are you using an insert cursor?

Re: Arcgis datetime format python

GarretVo — Mon, 18 Oct 2021 14:39:34 GMT

Hi all. I figure it out. Thank you for all your help. I just have one more question. When I export my data to arcgis online, the time is displayed as 8 hour ahead. Do you know how to change that to the original time in my data ? Thanks

For example, in my data, the time column is 4/22/2021 12:01:00. When the data comes into arcgis, the time column is 4/22/2021 8:00 PM. I want the time to be 12:01:00. Do you guys have any ideas? Thanks

Re: Arcgis datetime format python

BlakeTerhune — Mon, 18 Oct 2021 16:02:43 GMT

Work with date fields—ArcGIS Online Help | Documentation

All dates in ArcGIS Online are assumed to be UTC. You might need to convert the time before you upload the data.