agora inbox for pgsql-interfaces@postgresql.org
help / color / mirror / Atom feedFrom: David Wall <d.wall@computer.org>
To: pgsql-interfaces@postgresql.org
Subject: Re: Which Java class in the new java.time package shall be used to mapped timestamp?
Date: Tue, 11 Mar 2014 15:37:46 -0700
Message-ID: <531F903A.5030604@computer.org> (raw)
In-Reply-To: <1821595371.107318.1394574876616.JavaMail.mail@webmail16>
References: <1821595371.107318.1394574876616.JavaMail.mail@webmail16>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-interfaces>
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 (pgsql-interfaces@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces
view thread (2+ messages)
Message-ID: <531F903A.5030604@computer.org>
Permalink: ../531F903A.5030604@computer.org/
Also on: postgresql.org/message-id/531F903A.5030604@computer.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: d.wall@computer.org
Subject: Re: Which Java class in the new java.time package shall be used to mapped timestamp?
In-Reply-To: <531F903A.5030604@computer.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox