[ https://issues.apache.org/jira/browse/OFBIZ-5608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14600994#comment-14600994 ]
Gareth Carter commented on OFBIZ-5608: -------------------------------------- It looks fine. I have concerns though about all the existing fields that use SQL Date - will these get updated with ignore-time-zone="true"? With a little digging I can see the following entities that use SQL Date: $ grep -R --exclude-dir=.svn --include=*.xml "type=\"date\"" . | grep "entitydef" ./applications/accounting/entitydef/entitymodel.xml: <field name="expectedEndOfLife" type="date"></field> ./applications/accounting/entitydef/entitymodel.xml: <field name="actualEndOfLife" type="date"></field> ./applications/accounting/entitydef/entitymodel.xml: <field name="dueDate" type="date"></field> ./applications/humanres/entitydef/entitymodel.xml: <field name="jobRequisitionDate" type="date"></field> ./applications/humanres/entitydef/entitymodel.xml: <field name="requiredOnDate" type="date"></field> ./applications/humanres/entitydef/entitymodel.xml: <field name="jobInterviewDate" type="date"></field> ./applications/manufacturing/entitydef/entitymodel.xml: <field name="exceptionDateStart" type="date"></field> ./applications/order/entitydef/entitymodel.xml: <field name="entryDate" type="date"></field> ./applications/party/entitydef/entitymodel.xml: <field name="birthDate" type="date"></field> ./applications/party/entitydef/entitymodel.xml: <field name="deceasedDate" type="date"></field> ./applications/party/entitydef/entitymodel.xml: <field name="passportExpireDate" type="date"></field> ./framework/common/entitydef/entitymodel.xml: <field name="fromDate" type="date"></field> ./framework/common/entitydef/entitymodel.xml: <field name="thruDate" type="date"></field> ./framework/entity/entitydef/entitymodel_test.xml: <field name="dateField" type="date"/> ./specialpurpose/bi/entitydef/entitymodel.xml: <field name="dateValue" type="date"> > 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: Release Branch 12.04, Release Branch 13.07, Trunk > Reporter: Rupert Howell > Priority: Minor > Attachments: IgnoreTimeZone.patch, ObjectTypeTests.patch, > dates.patch, dates_1589040.patch, sqldate_scenarios.png > > > Dates are displaying incorrectly when negative offset (relative to UTC) are > applied by the users settings. -- This message was sent by Atlassian JIRA (v6.3.4#6332)