I would like to make it so that as a feature class is edited the "modifiedDate" and "user" fields will be updated automatically. Is there a way to do this?
I just enable editor tracking in the feature class, I noticed that in the LAST_EDITED_DATE field, the current time is incorrect (the date is correct though). Did any of you have the same experience? Thanks!
Yes, we're in the Eastern time, but it records the Pacific time. Also when I query the current timestamp from the oracle database, it shows the correct timestamp. Thanks!
Do you have the TZ environment variable set explicitly on both the Windows Desktop host and the database server? Without an explicit TZ, there's a great deal of room for interpretation.
Do you have the TZ environment variable set explicitly on both the Windows Desktop host and the database server? Without an explicit TZ, there's a great deal of room for interpretation.
- V
It does not seem like we have TZ enviroment variable set up. Could you tell what we need to set up? Thanks for your help!
This is complicated enough that you really need to research it yourself to be sure you know what happens is what you want to hapen. A google on "tz oracle variable" will get you started. If you were using Direct Connect I doubt this would be an issue.
