Received: from diamond.sierra.net (diamond.sierra.net [207.135.245.182]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA77304 for ; Sun, 21 May 2000 18:08:26 -0400 (EDT) (envelope-from christopher@baus.net) Received: from kirkwood ([207.135.230.18]) by diamond.sierra.net (8.9.3/8.9.3) with SMTP id PAA28157 for ; Sun, 21 May 2000 15:00:31 -0700 (PDT) Message-ID: <09b801bfc36f$32b0d8a0$9500a8c0@styleadvisor.com> From: "christopher baus" To: References: <200005210739.DAA56258@hub.org> Subject: date format question. Date: Sun, 21 May 2000 14:54:53 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Archive-Number: 200005/28 Hi all, I just started using postgreSQL 7.0 and the JDBC 1.1 driver with apache's turbine project. I am a bit confused by your date handling. Turbine uses timestamp fields to stamp user login/logout. The driver allows me to set the login in the following format : 2000-05-21 02:04:12.33-04 When I requery the field the driver throws an invalid date format exception. I would like to be able to be assured that a java date will be transformed to the proper format. I'm not an expert in the JDBC spec, but it seems the other drivers I've tried do this. ~christopher