topic ArcGIS Versioned Archive Dates Not in UTC in Geodatabase Questions

ArcGIS Versioned Archive Dates Not in UTC

JoseSousa — Tue, 11 Jul 2017 21:51:28 GMT

Hi,

I have noticed that the dates being pushed to versioned archive tables "_H" GDB_FROM_DATE and GDB_TO_DATE are local not in UTC. Is there a way to change this behavior?

Cheers,

Jose

Re: ArcGIS Versioned Archive Dates Not in UTC

Asrujit_SenGupta — Wed, 12 Jul 2017 05:52:07 GMT

No, we don't have that flexibility yet.

The archive process—ArcGIS Help | ArcGIS Desktop

Working with historical versions—ArcGIS Help | ArcGIS Desktop

When working with archived information, it is important to understand that the date and time recorded in the gdb_from_date and the gdb_to_date fields of the archive reflect the date and time a transaction took place—when a feature was added, edited, or removed from the feature class. This date and time is received from the server OS. This affects how you access and query the archive.

Re: ArcGIS Versioned Archive Dates Not in UTC

JoseSousa — Wed, 12 Jul 2017 22:26:10 GMT

Hi Asrujit,

Thanks for replying. I hope this is implemented somewhere in time.

Cheers,

Jose

Re: ArcGIS Versioned Archive Dates Not in UTC

andysp — Thu, 04 Oct 2018 14:58:34 GMT

Just in case anyone else happens upon this thread: we typically have versioned feature classes with Editor Tracking enabled. We have recently started to implement archiving. Our editor tracking timestamps are in UTC and our archive table (_H) timestamps are in local time.

However, it appears that for nonversioned data, the archive timestamps are in UTC rather than local time. (Editor tracking timestamps are still in UTC as well.)

This is on 10.4.1 with an Oracle back end; YMMV.