[
https://issues.apache.org/jira/browse/OFBIZ-5608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13976894#comment-13976894
]
Gareth Carter commented on OFBIZ-5608:
--------------------------------------
No where. SQL dates don't have a time component, the jdbc driver (or all
drivers) have to to set the time in java.sql.Date simply because it inherits
from java.util.Date which does have a time component. It doesn't matter which
timezone you pick on the database, the sql date fields never change.
Reading up on SQL standards
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
"Therefore, datetime data types that contain time fields (TIME and
TIMESTAMP) are maintained in Universal Coordinated Time (UTC), with
an explicit or implied time zone part."
Seems to suggest that only fields with a time component should only be affected
by timezone
> Dates Displaying Incorrectly With Negative Offest Timezones.
> ------------------------------------------------------------
>
> Key: OFBIZ-5608
> URL: https://issues.apache.org/jira/browse/OFBIZ-5608
> Project: OFBiz
> Issue Type: Bug
> Components: ALL COMPONENTS
> Affects Versions: SVN trunk, Release Branch 12.04, Release Branch 13.07
> Reporter: Rupert Howell
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: dates.patch, dates_1589040.patch
>
>
> Dates are displaying incorrectly when negative offset (relative to UTC) are
> applied by the users settings.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
