JDBC ZonedDateTime problem
Blake McBride <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <CABwHSOvcM3zM3WW4e+BBKYNxhHcEcBUXxbBc_t1aje3oxVri+w@mail.gmail.com> |
Greeings, I am using PostgreSQL 9.3.19 on a 64 bit Linux box with postgresql-42.1.4.jar and 64 bit Java 8. I am doing setObject with ZonedDateTime.now(ZoneOffset.UTC) and I get: org.postgresql.util.PSQLException: Can't infer the SQL type to use for an instance of java.time.ZonedDateTime. Use setObject() with an explicit Types value to specify the type to use. What I am trying to do is set the column to the current datetime UTC. Any help would sure be appreciated! Blake McBride