[ https://issues.apache.org/jira/browse/OFBIZ-5608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gareth Carter updated OFBIZ-5608: --------------------------------- Attachment: sqldate_scenarios.png As suggested by Adrian, I have attached an image of 3 flow diagrams depicting what I believe is happening when using java.sql.Date and db type SQL DATE with different timezones for user, app server and database server. > 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: 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)