Hello all,
I encounter strange (for me) problem with SQL Developer 17.4.0.355 on Fedora Linux 27, db server is Oracle 11g XE on the same machine. SQL Developer seems to display incorrect data for column of datatype TIMESTAMP WITH LOCAL TIME ZONE, for different session settings (different time zones) it still shows value for time zone of OS even if data has been inserted from other time zone. At the same time - sqlplus shows correct data so I guess it's an issue with SQL Developer.
Please find below very simple test case:
create table a (
tz timestamp with time zone
,tl timestamp with local time zone
);
select sessiontimezone,dbtimezone from dual;
alter session set time_zone='Asia/Hong_Kong';
insert into a values (localtimestamp,localtimestamp);
commit;
alter session set time_zone='America/New_York';
insert into a values (localtimestamp,localtimestamp);
commit;
select * from a;
Do you have any suggestions? Any ideas what should I check? Perhaps I missed something but as I mentioned - sqlplus seems to work fine.
Thank you for your support!
Best regards,
Andrzej