Hi,

Our client in Fiji is going for DST change starting from this year. When I am querying the views (created using cre_tz_views.sql) i found dbtimezome is different in some databases. In some databases it is +12, in some +5, and in some -7.

The query I used is 'select dbtimezone from dual;'

None of the applications are using names timezone data types.

Appreciate your input to know how the difference in dbtimezone makes difference.

Thanks,