Enterprise geodatabase: Updated timestamp and timezone

1073
2
05-11-2019 08:27 AM
UalasRohrer
New Contributor III

Hello!

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

  1. 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?
  2. 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

0 Kudos
2 Replies
Asrujit_SenGupta
MVP Regular Contributor

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).

0 Kudos
BirajaNayak
Esri Contributor

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

0 Kudos