Geodatabase View with Oracle 19c containing Timestamp Offset fields raises an error: SE_DBTIMESTAMPTZINFO object not initialized.

解决办法

Use to_char() syntax to return the offset timestamp as text in the SQL, noting this will limit any date calculations or query logic using this field but is sufficient for visualization.

select objectid ,created_date ,to_char(created_date at time zone 'UTC') "CREATION_DATE" ,last_edited_date , to_char(last_edited_date at time zone 'UTC') "UPDATED_DATE" from sdo.my_fc

重现步骤