Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-interfaces-owner+M7034=pgsql-interfaces-ark@postgresql.org>)
 id 1WNUdK-0004XO-0I
 for pgsql-interfaces@arkaria.postgresql.org; Tue, 11 Mar 2014 21:54:46 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-interfaces-owner+M7034=pgsql-interfaces-ark@postgresql.org>)
 id 1WNUdH-0002YS-MY
 for pgsql-interfaces@arkaria.postgresql.org; Tue, 11 Mar 2014 21:54:43 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <vwu98034@lycos.com>) id 1WNUdG-0002YL-Pf
 for pgsql-interfaces@postgresql.org; Tue, 11 Mar 2014 21:54:42 +0000
Received: from smtprelay0115.b.hostedemail.com ([64.98.42.115]
 helo=smtprelay.b.hostedemail.com)
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <vwu98034@lycos.com>) id 1WNUdE-0000av-5o
 for pgsql-interfaces@postgresql.org; Tue, 11 Mar 2014 21:54:42 +0000
Received: from filter.hostedemail.com (b-bigip1 [10.5.19.254])
 by smtprelay05.b.hostedemail.com (Postfix) with ESMTP id 3E28032AFA5
 for <pgsql-interfaces@postgresql.org>; Tue, 11 Mar 2014 21:54:38 +0000 (UTC)
X-Session-Marker: 7677753938303334406C79636F732E636F6D
X-Spam-Summary: 10, 1, 0, , d41d8cd98f00b204, vwu98034@lycos.com, :,
 RULES_HIT:41:152:355:375:379:541:582:973:988:989:1152:1224:1260:1311:1313:1314:1345:1373:1437:1515:1516:1517:1534:1538:1566:1593:1594:1699:1711:1714:1730:1747:1777:1792:2393:2557:2559:2562:2693:2892:3138:3139:3140:3141:3142:3586:3769:3865:3866:3867:3868:3870:3871:3873:5007:6261:8957:10007:10400:10848:11658:11914:12438:12517:12519:12679:13139:13255:13311:13357:13972,
 0, RBL:none, CacheIP:none, Bayesian:0.5, 0.5, 0.5, Netcheck:none,
 DomainCache:0, MSF:not bulk, SPF:fn, MSBL:0, DNSBL:none, Custom_rules:0:1:0
X-HE-Tag: actor46_7f91a46d00121
X-Filterd-Recvd-Size: 1213
Received: from webmail16 (imap-ext [64.98.36.5])
 (Authenticated sender: vwu98034@lycos.com)
 by omf11.b.hostedemail.com (Postfix) with ESMTPA
 for <pgsql-interfaces@postgresql.org>; Tue, 11 Mar 2014 21:54:36 +0000 (UTC)
Received: from 67.168.77.33 ([67.168.77.33]) by webmail16 (Webmail) with HTTP;
 Tue, 11 Mar 2014 21:54:36 +0000 (UTC)
Date: Tue, 11 Mar 2014 21:54:36 +0000 (UTC)
From: Vernon E <vwu98034@lycos.com>
To: pgsql-interfaces@postgresql.org
Message-ID: <1821595371.107318.1394574876616.JavaMail.mail@webmail16>
Subject: Which Java class in the new java.time package shall be used to
 mapped timestamp?
MIME-Version: 1.0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Mailer: Webmail
X-Originating-IP: [67.168.77.33]
X-Pg-Spam-Score: 2.2 (++)
List-Archive: <http://archives.postgresql.org/pgsql-interfaces>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-interfaces.postgresql.org>
List-Owner: <mailto:pgsql-interfaces-owner@postgresql.org>
List-Post: <mailto:pgsql-interfaces@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-interfaces>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-interfaces>
X-Mailing-List: pgsql-interfaces
Precedence: bulk
Sender: pgsql-interfaces-owner@postgresql.org

<div>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:</div>
<div>&nbsp;</div>
<div>
<pre>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.<br /><br />Which class I shall use?<br /><br /><br /><br /></pre>
</div>