Recently we have acquired assets for our company which require us to support our systems across multiple time zones which currently we only needed EST. Our database is 19.29 using the container/pluggable model of both which DBTIMZEONE set to EST time zone.
Oracle DB seems to promote using the TIMESTAMP WITH LOCAL TIME ZONE datatype as that automatically switches between the DB and the CLIENT based on SESSIONTIMEZONE vs DBTIMEZONE. Does that work with Forms/Report or do you use standard TIMESTAMP WITH TIMEZONE and use the forms ENV vars FORMS_TZ_SERVER and FORMS_TZ_CLIENT.
Currently our DATE/TIME data is stored as a plain DATE which does not understand any of the above and will require change. Any ideas or suggestions would be greated.