DATE and TIMESTAMP Pickers not Showing Same Windows Workstation Time
Last updated on FEBRUARY 26, 2018
Applies to:Oracle SQL Developer - Version 17.4 and later
Information in this document applies to any platform.
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.
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.
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