[PHOENIX-6949] Use j.u.Date.getTimeOffset() for displacement calculation

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: core
• Assignee: Unassigned
• Reporter: Istvan Toth
• Created: 05/May/23 06:40
• Updated: 08/May/23 08:13

Description

The current code calculates the offset from the current timezone.
However, java.util.Date and its children (java.sql.Date*) already provide the getTimeOffset()  for the same.

This has the added benefit that in the unlikely case that we receive the a java.sql.Date that is not in the JVM timezone, then we use its offset correctly.

Issue Links

• is caused by: PHOENIX-5066 The TimeZone is incorrectly used during writing or reading data
• is depended upon by: PHOENIX-6882 Umbrella Ticket for date/time handling issues
• links to: discussion of the perf issue for Postgres
• links to: GitHub Pull Request #1602