Received: from mailhost.iworld.com ([63.95.15.3]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f09MnqB60813 for ; Tue, 9 Jan 2001 17:49:52 -0500 (EST) (envelope-from mcannon@internet.com) Received: by mailhost.iworld.com; id RAA19166; Tue, 9 Jan 2001 17:49:49 -0500 (EST) Received: from nodnsquery(203.111.125.102) by darienfw1.iworld.com via smap (V5.5) id xma018994; Tue, 9 Jan 01 17:49:07 -0500 Reply-To: From: "Mike Cannon-Brookes" To: "Pgsql-Interfaces@Postgresql. Org" Subject: JDBC date problem Date: Wed, 10 Jan 2001 09:53:26 +1100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200101/80 X-Sequence-Number: 689 I'm having a problem with dates in the JDBC driver. They are being mangled when they come through from the database, here are some examples: > Postgres: Java: > 2000-12-20 16:11:00+11 Nov 20 16:00:00 EST 2000 (looks like it's pulling the month from the timezone or minute field?) It gets worse ;) > Postgres: Java: > 2001-01-03 17:35:00+11 Nov 03 17:00:00 EST 2003 (again, month comes from the timezone field, but 2004?! ;)) And worse still... > Postgres: Java: > 2001-01-02 18:41:00+11 May 02 17:00:00 EST 2004 (now I'm not really sure where anything came from here, besides the day - every other number seems wrong?) Some raw data: Postgres: Java: 2000-12-20 16:11:00+11 | 2000-11-20 16:00:00 2001-01-02 18:41:00+11 | 2004-05-02 17:00:00 2001-01-03 17:35:00+11 | 2003-11-03 17:00:00 2000-12-20 15:00:00+11 | 1999-12-20 15:00:00 2001-01-04 19:00:00+11 | 2000-12-04 19:00:00 2001-01-09 11:00:00+11 | 2000-12-09 11:00:00 Any ideas? This is a real stumper and I need to find a solution asap! I'm using a JDBC driver I built from CVS no more than a month ago. -mike ____________________________________________________________ Mike Cannon-Brookes - Technology Director, Asia Pacific internet.com Corporation - The Internet Industry Portal Ph: (612) 9290 1088 - Mob: 0416 106090 - The Media Network @ http://australia.internet.com - Meet A Guru @ http://www.breakfastforums.com.au - Subscribe Online @ http://www.enewsletters.com.au ____________________________________________________________