DATE and TIMESTAMP Pickers not Showing Same Windows Workstation Time

(Doc ID 2366041.1)

Last updated on FEBRUARY 26, 2018

Applies to:

Oracle SQL Developer - Version 17.4 and later
Information in this document applies to any platform.

Symptoms

In SQL Developer when trying to modify a DATE or TIMESTAMP value from the data grid using the available picker, it wont show the same time that the Windows workstation is displaying but the time in GMT/UTC.

Example

1- Select a date column from a table and go to the Data Grid.

2- Double click on one record and then select the Pencil icon.

3- Click on the NOW button.

The Time value displayed wont match the time on  the Windows workstation.

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms