[
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)
Locked
