Re: Which Java class in the new java.time package shall be used to mapped timestamp?
David Wall <[email protected]> Tue, 11 Mar 2014 15:37:46 -0700
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <[email protected]> |
On 3/11/2014 2:54 PM, Vernon E wrote: > I have tried both LocalDateTime (without time zone informatio) and > ZonedDateTime (with time zone information) in the new java.time > package and get a same error: > column "registeration_datetime" is of type timestamp without time zone but expression is of type bytea > Hint: You will need to rewrite or cast the expression. > > Which class I shall use? java.sql.Timestamp is the normal type that maps to a PG timestamp field, and I'd recommend TIMESTAMP WITH TIME ZONE unless you are sure the time part is really not important. -- Sent via pgsql-interfaces mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-interfaces