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
