topic Re: Enterprise geodatabase: Updated timestamp and timezone in Geodatabase Questions

Enterprise geodatabase: Updated timestamp and timezone

UalasRohrer — Sat, 11 May 2019 15:27:09 GMT

Hello!

I have deployed a Enterprise Geodatabase in a PostgreSQL server and would like to request support in two questions:

How can I SQL query the geodatabase to return me the Last Updated Time for each feature (feature class row). I`m pretty sure that there is something like this is used to control versioned data. Or is the Edit Tracking setting the only way to do this?
The geodatabase is using a wrong timezone, I`ve already changed the ubuntu timezone but it didn`t affect the geodatabase. I`m not sure if this is a PostgreSQL setting.

Thanks,

Ualas Rohrer

Re: Enterprise geodatabase: Updated timestamp and timezone

Asrujit_SenGupta — Sun, 12 May 2019 07:47:51 GMT

1. Out of the box, Editor Tracking..but this will not track deletes

2. How To: Enable editor tracking to record time in database time

Enable Editor Tracking—Help | ArcGIS Desktop

You can record the dates of edits in either the database's time zone or in UTC (Coordinated Universal Time).

Re: Enterprise geodatabase: Updated timestamp and timezone

BirajaNayak — Tue, 14 May 2019 00:28:26 GMT

Hi Ualas,

What version type you are following:

1. Transaction versioning

2. Branch versioning ( This is based on time stamp)

Regarding timezone, you can capture data and time in PorstgreSQL itself without ArcGIS and check what timezone it is capturing. That will help to narrow down the Timezone issue.

Regards,

Biraja