{"push_id":1046653021,"size":1,"distinct_size":1,"ref":"refs/heads/master","head":"021bd5ebe342c244685c553ee5aec8a73772f88f","before":"41a3b568d373fec72166d3599221a0d23529b3c5","commits":[{"sha":"021bd5ebe342c244685c553ee5aec8a73772f88f","author":{"email":"8c320595b2ccfc174fc5d4233dad991b8adaa646@gmail.com","name":"Xavier Fernández Salas"},"message":"Issue-#1026: Support 'java.time' classes as JDBC types\n\n- Add support as JDBC types for the following classes:\n\n* java.time.OffsetDateTime\n* java.time.ZonedDateTime\n* java.time.LocalDate\n* java.time.LocalTime\n* java.time.LocalDateTime\n* java.time.Instant\n* java.time.OffsetTime\n\n- The generic implementation of the following classes are implemented\n  are done using VARCHAR because the data type ‘TIMESTAMP WITH TIMEZONE’\n  is not available in almost any database.\n\n* java.time.OffsetTime\n* java.time.OffsetDateTime\n* java.time.ZonedDateTime\n\n- The generic implementation of LocalTime is persisted as a VARCHAR,\n  because ANSI SQL stores TIME with a second presicion and LocalTime\n  has a millisecond one. Doing that we avoid losing any type of precision.\n  Databases supporting time with milliseconds have a native implementation\n  of this data type.\n\n- The following classes are implemented natively on all databases:\n\n* java.time.Instant\n* java.time.LocalDate\n* java.time.LocalDateTime\n\n- The following classes are implemented natively on Hsqldb:\n\n* java.time.LocalTime\n* java.time.OffsetTime\n* java.time.OffsetDateTime\n\n- The following classes are implemented natively on PostgreSQL:\n\n* java.time.LocalTime\n* java.time.OffsetTime\n\n- The following classes are implemented natively on OracleSQL:\n\n* java.time.LocalDate\n* java.time.LocalTime (using the TIMESTAMP data type)\n* java.time.OffsetTime (using the TIMESTAMP data type)\n* java.time.OffsetDateTime\n* java.time.Instant\n* java.time.OffsetDateTime\n* java.time.ZonedDateTime\n\n- MySQL stores time in secons, so all this elements are persisted as\n  VARCHAR, in order to avoid losing precision.\n\n- PostgreSQL have a native implementation for all the java.time classes\n  except ZonedDateTime and OffsetDateTime because PostgreSQL do not store\n  the offset, it stores everything in UTC.","distinct":true,"url":"https://api.github.com/repos/xavier-fernandez/slick/commits/021bd5ebe342c244685c553ee5aec8a73772f88f"}]}