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

Reply via email to