Message-ID: <531F903A.5030604@computer.org>
Date: Tue, 11 Mar 2014 15:37:46 -0700
From: David Wall <d.wall@computer.org>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.3.0
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Re: Which Java class in the new java.time package shall
 be used to mapped timestamp?
References: <1821595371.107318.1394574876616.JavaMail.mail@webmail16>
In-Reply-To: <1821595371.107318.1394574876616.JavaMail.mail@webmail16>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-interfaces-owner@postgresql.org

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