[
https://issues.apache.org/jira/browse/OFBIZ-5608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15006032#comment-15006032 ]
Jacques Le Roux commented on OFBIZ-5608:
----------------------------------------
Hi Gareth,
I did a similar search in Eclipse and got exactly the same result (15 entries). They are:
* FixedAsset
** expectedEndOfLife
** actualEndOfLife
* AcctgTransEntry
** dueDate
* JobRequisition
** jobRequisitionDate
** requiredOnDate
* JobInterview
** jobInterviewDate
* TechDataCalendarExcWeek
** exceptionDateStart
* OrderSummaryEntry
** entryDate
* Person
** birthDate
** deceasedDate
** passportExpireDate
* CustomTimePeriod
** fromDate
** thruDate
* TestFieldType
** dateField
* DateDimension
** dateValue
It seems to me that all these dates are plain dates (aka SQL Date/java.sql.Date) and not date-times (aka SQL TIMESTAMPTZ/java.sql.Timestamp). So no issues expected there.
I also did a research of {code}<date-time*type="date"*/>{code} in \*form\*.xml files and found 42 entries. So, it's a bit harder to review, not only because of the number but also because fields names speak less for themselves. I still expect that if the specific type="date" has been selected a SQL date is supposed, not a Timestamp.
For FTL templates it's finally easier than supposed. There is only 4 shortDateInput=true cases, with 2 in Webtools. Unfortunately it does not seems to work correctly.
I noted this Adrian's comment in MacroFormRenderer:
// FIXME: modelFormField.getEntry ignores shortDateInput when converting Date objects to Strings.
This is another subject; so another issue should be created... A maybe related issue is if you set shortDateInput=true in order manager optionsettings.ftl, when you come back to the screen, the calendar button does not appear.
To summarize I believe we should make true by defaut the ignore-time-zone and specifically handle cases where it does not fit. They should not be many because they are anomalies if we consider that a plain date has no time associated.
> 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
> Assignee: Jacques Le Roux
> 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
