Our application saves timestamp with TZ fields with the region not the exact time offset.
01.04.2021 12:00:00,0000 Europe/Berlin
if I display this record in TOAD for Oracle (Version 14.0.75...) it ist shown as
01.04.2021 12:00:00,0000 +02:00
This cannot be changed.
Now when I update one other field in the same record also the timestamp with TZ value is update and afterwards the record has no longer the region information (Europe/Berlin) in it but the time offset (+02:00). This might not be a problem for values in the next few years, but we save values for the year 2040+. In this case it already happened, that countries decided to stop using the daylight saving switch. Now the timestamp will be no longer correct!
Could you please check and advice?