Enterprise geodatabase: Updated timestamp and timezone

[UalasRohrer]

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

[Asrujit_SenGupta]

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

[BirajaNayak]

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