[
https://issues.apache.org/jira/browse/OFBIZ-5608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13978016#comment-13978016 ]
Rupert Howell commented on OFBIZ-5608:
--------------------------------------
That comment directly disagrees with the javadocs.
From the java docs for java.sql.Date which is a subclass of java.util.Date and what is pulled back from the DB and converted to a java.util.Date then formatted.
To conform with the definition of SQL DATE, the millisecond values wrapped by a java.sql.Date instance must be 'normalized' by setting the hours, minutes, seconds, and milliseconds to zero in the particular time zone with which the instance is associated.
http://docs.oracle.com/javase/7/docs/api/java/sql/Date.htmlWhich is EXACTLY what I am seeing. Any negative offset applied moves the date back a day because as far as the formatter is concerned its midnight and needs to be changed to 11pm the previous night.
} else if (retVal instanceof java.sql.Date) {
DateFormat df = UtilDateTime.toDateFormat(UtilDateTime.DATE_FORMAT, timeZone, null);
return df.format((java.util.Date) retVal);
> 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: ObjectTypeTests.patch, 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)
Locked
