Thanks David, reviewing now - I have some questions we can discuss on the ticket. (My own understanding of geopackage is no doubt the limiting factor here) -- Jody Garnett
On Tue, 10 Mar 2020 at 14:17, David Blasby <david.bla...@geocat.net> wrote: > I put together a pull request - very minor change. I also put in a test > case that messes with the timezone -- hopefully this will make sure this > doesn't happen again. > > https://github.com/geotools/geotools/pull/2837 > > Thanks for the help/ideas/code Andrea! Couldn't have done it without you! > > dave > > On Tue, Mar 10, 2020 at 11:19 AM Andrea Aime <andrea.a...@geo-solutions.it> > wrote: > >> I've found the flags related to local date handling: >> >> https://github.com/geotools/geotools/blob/029dc5c8ccc503de3cfd7f4d1c939d8056c260c4/modules/library/metadata/src/main/java/org/geotools/util/factory/GeoTools.java#L239 >> >> https://github.com/geotools/geotools/blob/029dc5c8ccc503de3cfd7f4d1c939d8056c260c4/modules/library/metadata/src/main/java/org/geotools/util/factory/Hints.java#L992 >> >> However they seem to be affecting only GML encoding, not JDBC code >> directly. >> I'm guessing that in JDBC land java.sql.Date fields are treated as >> without a time zone? Not sure. >> See also this page of documentation about PostgreSQL: >> https://www.postgresql.org/docs/9.1/datatype-datetime.html >> Quoting: "The SQL standard requires that writing just timestamp be >> equivalent to timestamp without time zone" >> >> Cheers >> Andrea >> >> >> On Tue, Mar 10, 2020 at 7:01 PM David Blasby <david.bla...@geocat.net> >> wrote: >> >>> I'll look into the problem this afternoon. >>> >>> The timezone handling in sql lite is very limited and confusing. >>> >>> Cheers, >>> David >>> _______________________________________________ >>> GeoTools-Devel mailing list >>> GeoTools-Devel@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/geotools-devel >>> >> >> >> -- >> >> Regards, Andrea Aime == GeoServer Professional Services from the experts! >> Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime >> @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 >> Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 >> 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it >> ------------------------------------------------------- *Con riferimento >> alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - >> Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni >> circostanza inerente alla presente email (il suo contenuto, gli eventuali >> allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i >> destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per >> errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le >> sarei comunque grato se potesse darmene notizia. This email is intended >> only for the person or entity to which it is addressed and may contain >> information that is privileged, confidential or otherwise protected from >> disclosure. We remind that - as provided by European Regulation 2016/679 >> “GDPR” - copying, dissemination or use of this e-mail or the information >> herein by anyone other than the intended recipient is prohibited. If you >> have received this email by mistake, please notify us immediately by >> telephone or e-mail.* >> > _______________________________________________ > GeoTools-Devel mailing list > GeoTools-Devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geotools-devel >
_______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
