PROBLEM

The Date field values are different in a file geodatabase exported from a hosted feature service

Last Published: April 25, 2020

Description

After exporting data to a file geodatabase from ArcGIS Online, the date values are different from the date displayed in the hosted feature service. For instance, a date value displayed in ArcGIS Online as 6/22/2017 2:44 PM' become '22/6/2017 6:44:13 AM'.
 

Mix
 
 

Cause

ArcGIS Online stores date values in Coordinated Universal Time (UTC) instead of the local time zone. Dates are assumed to be in the UTC format by default because the physical location of the server hosting the data can be anywhere in the world. The alternative of storing date and time in a local time zone leads to all sorts of problems, especially if the user or the server hosting the data moves to another time zone.

Solution or Workaround

Convert the time values to the desired time zone using the Convert Time Zone tool in ArcMap.
  1.  In the Catalog pane, navigate to Toolboxes > System Toolboxes > Data Management Tools > Field > Convert Time Zone.
Tools
  1. In the Convert Time Zone dialog box, select a layer from the drop-down list.
  2. Select the date field as Input Time Field.
  3. Select (UTC) Coordinated Universal Time from the Input Time Zone drop-down list.
Input
  1. Select the appropriate time zone for the data from the Output Time Zone drop-down list.
Output
 
  1. Click OK. A new date field with converted date values is added to the attribute table.
Mix1

Article ID: 000015876

Software:
  • ArcMap
  • ArcGIS Online

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options