Re: [hibernate-dev] 6.0 - HQL literals

2020-01-13 Thread Yoann Rodiere
>> As far as I know there wasn't any specific time-related problem with the org.postgresql:postrgresql driver. I'm not sure we run tests against pgjdbc, that might be something to consider. > Please do run your tests against that. My bad, we do run our tests against that. I confused it with pgjdb

Re: [hibernate-dev] 6.0 - HQL literals

2020-01-13 Thread Dave Cramer
Dave Cramer On Mon, 13 Jan 2020 at 11:10, Yoann Rodiere wrote: > Hi, > > As far as I know there wasn't any specific time-related problem with the > org.postgresql:postrgresql driver. I'm not sure we run tests against > pgjdbc, that might be something to consider. > Please do run your tests aga

Re: [hibernate-dev] 6.0 - HQL literals

2020-01-13 Thread Yoann Rodiere
Hi, As far as I know there wasn't any specific time-related problem with the org.postgresql:postrgresql driver. I'm not sure we run tests against pgjdbc, that might be something to consider. The problems were mainly with MariaDB/MySQL/Sybase drivers, and we upgraded our dependencies since then, so

Re: [hibernate-dev] 6.0 - HQL literals

2020-01-13 Thread Dave Cramer
Hi Steve, I'm not sure there is a better way to store the data in the database. Doing any kind of date/time math in anything else but UTC seems fraught with danger. See below as to how we handle Java 8 types. https://github.com/pgjdbc/pgjdbc/blob/db228a4ffd8b356a9028363b35b0eb9055ea53f0/pgjdbc/s