SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datepicker 'Now' button always returns GMT date.

YanovicDec 20 2017 — edited Dec 20 2017

Hello

In SQL Developer 17.3.1.2798,

when editing date columns using the date picker the 'Now' button always sets the time to the GMT timezone instead of using the local or server timezone settings.

Is this a bug? I've seen threads like this one before as for versions as early as 4.0.1

I did run the following:

select dbtimezone, sessiontimezone from dual;

returning dbtimezone = +00:00, sessiontimezone = America/New_York.

I tried to alter the session time zone to 'EST' but It has no effect on the date picker.

Is there a fix or work around for this bug?

Thanks,

Yan

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 17 2018

Added on Dec 20 2017

#sql-developer

2 comments

174 views