AnsweredAssumed Answered

Enterprise geodatabase: Updated timestamp and timezone

Question asked by ubr1@rice.edu on May 11, 2019
Latest reply on May 13, 2019 by bnayak-esristaff

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

Outcomes