Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2016-02-17 Thread Jody Garnett
Thank you for your prompt response. Reviewing now. -- Jody Garnett On 16 February 2016 at 02:54, Andreas Watermeyer < andreas.waterme...@its-telco.de> wrote: > Hi all, > > I have created two pull requests for the local date issue. > > GeoTools: > Pull request: https://github.com/geotools/geotool

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2016-02-16 Thread Andreas Watermeyer
Hi all, I have created two pull requests for the local date issue. GeoTools: Pull request: https://github.com/geotools/geotools/pull/1116 Issue: https://osgeo-org.atlassian.net/browse/GEOT-5329 GeoServer: Pull request: https://github.com/geoserver/geoserver/pull/1491 Issue: https://osgeo-org.atl

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2016-02-15 Thread Andreas Watermeyer
Hi all, I have created a new pull request for this topic consisting of one commit only. Regarding the GeoServer part (sort of cross-posting): I will create a corresponding pull request. The GeoServer implementation (org.geoserver.wfs.xml.xs.DateBinding) is a subclass of the GeoTools implementati

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2016-02-15 Thread Andrea Aime
On Mon, Feb 15, 2016 at 9:21 AM, Andreas Watermeyer < andreas.waterme...@its-telco.de> wrote: > Hi all, > > I am currently quite busy, but I really like to see this solved, too. > I also appreciate your support so I will give it a try right now. > I hope it will not break other things, so close be

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2016-02-15 Thread Andreas Watermeyer
Hi all, I am currently quite busy, but I really like to see this solved, too. I also appreciate your support so I will give it a try right now. I hope it will not break other things, so close before code freeze. It would be nice if somebody somebody could help me if I have question regarding the s

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2016-02-13 Thread Andrea Aime
Hi Andreas, sorry, completely missed this mail of yours. On Tue, Jan 5, 2016 at 3:14 PM, Andreas Watermeyer < andreas.waterme...@its-telco.de> wrote: > @Everybody: What do you think? Is this a feasible solution? > +1 for me > > Any suggestions for the name of the hint? Maybe > - JAVA_SQL_DATE_

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2016-02-12 Thread Jody Garnett
Just want to follow up Andreas; your pull request has been a subject of discussion for each of the last two geotools meetings. Is this something you could have ready before the code freeze? Or should we stop pestering you ... -- Jody Garnett On 5 January 2016 at 06:14, Andreas Watermeyer < andre

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2016-01-05 Thread Andreas Watermeyer
Hi all, I'd like to come back to this topic once more, see below. 2016-01-04 11:15 GMT+01:00 Andrea Aime : > On Mon, Jan 4, 2016 at 11:00 AM, Andreas Watermeyer > wrote: > > Yep, but also the most expensive to implement :-) > a) is a bit of hack indeed, but I believe it would get what you need w

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2016-01-04 Thread Andrea Aime
On Mon, Jan 4, 2016 at 4:51 PM, Peter Borissow wrote: > If backward compatibility is an issue, perhaps instead of using the new > Java 8 classes, you can use a 3rd party library like Joda time: > > http://joda-time.sourceforge.net/quickstart.html > > They have a LocalDate, LocalTime, and LocalDat

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2016-01-04 Thread Peter Borissow
From: Andrea Aime To: Andreas Watermeyer Cc: Ian Turton ; geotools-devel Sent: Monday, January 4, 2016 5:15 AM Subject: Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones On Mon, Jan 4, 2016 at 11:00 AM, Andreas Watermeyer wrote: Hi Andrea

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2016-01-04 Thread Andrea Aime
On Mon, Jan 4, 2016 at 11:00 AM, Andreas Watermeyer < andreas.waterme...@its-telco.de> wrote: > Hi Andrea, > > thank you very much for your detailed response. > > I like your approach c) best because it is flexible enough and complete. > Yep, but also the most expensive to implement :-) a) is a b

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2016-01-04 Thread Andreas Watermeyer
Hi Andrea, thank you very much for your detailed response. I like your approach c) best because it is flexible enough and complete. I try to sum up: 1) In future releases of GT FeatureTypes may have attributes of type "LocalDate". Question: Which parts of GT have to be adjusted in order to hand

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2015-12-24 Thread Andrea Aime
On Mon, Dec 21, 2015 at 12:36 PM, Andreas Watermeyer < andreas.waterme...@its-telco.de> wrote: > Hi all, > > thank you very much for your response. > > I did some more research on this: > > Most important: I was wrong, dates can be time zoned: > http://www.w3.org/TR/xmlschema-2/#date. The XML spec

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2015-12-21 Thread Peter Borissow
: Monday, December 21, 2015 6:36 AM Subject: Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones Hi all, thank you very much for your response. I did some more research on this: Most important: I was wrong, dates can be time zoned: http://www.w3.org/TR/xmlschema-

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2015-12-21 Thread Andreas Watermeyer
Hi all, thank you very much for your response. I did some more research on this: Most important: I was wrong, dates can be time zoned: http://www.w3.org/TR/xmlschema-2/#date. The XML spec for dates and times is inspired by ISO 8601. Both, the XML spec and ISO 8601 allow the time zone postfix "Z"

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2015-12-19 Thread Ian Turton
I'd hate to reopen this can of worms - feel free to see https://github.com/geotools/geotools/pull/808 & https://github.com/geotools/geotools/pull/872 & https://github.com/geotools/geotools/pull/775 and probably more besides. There is no good way to handle dates going into and out of the Databases

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2015-12-18 Thread Andrea Aime
Hi Jody, there is indeed a chance this change will break CITE testing, however, we are running a old and buggy version of it. After six months of waiting for the new engine to be deployed on ares I've honestly lost interest and gave up (others feel free to resume the effort), but if we ever do get

Re: [Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2015-12-18 Thread Jody Garnett
Hey Andreas, interesting discussion. I just rejected a "workaround" ( https://github.com/geotools/geotools/pull/997) on a similar topic - dealing with dates far in the past. We tend to base our datastore / query / filter API off the WFS - in particular we may be able to check the OGC docs for cla

[Geotools-devel] GEOT-5329: Proposal to avoid Date-shifting due to Timezones

2015-12-18 Thread Andreas Watermeyer
Hi GeoTools-Developers, I recently created https://osgeo-org.atlassian.net/browse/GEOT-5329 to propose a patch to change GeoTools java.sql.Date to String conversion due to problems arising from timezones. Andrea Aime suggested involve this mailing list. Problem: A date (without time) in Postgres