Re: help with front/backend datatype converting

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: "Do, Leon \(Leon\)" <leondo(at)lucent(dot)com>
Cc: Dave Cramer <pg(at)fastcrypt(dot)com>, imad <immaad(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: help with front/backend datatype converting
Date: 2006-11-14 23:05:53
Message-ID: 455A4BD1.6020302@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Do, Leon (Leon) wrote:

> I think postgres has a few bugs in this area. When timezone doesn’t
> have a semicolon between hour and min, TimestampUtil.java cann’t handle
> it. The firstNonDigits method call below returns all four digits and
> assigns them to timezone hour variable.

Does the server ever generate timezones like this?

> And for the second bugs, fractional part of the second (e.g.
> 14:36:19.213000) seem to be interpreted incorrectly when converting to
> Java Date. 213000 would round up as additional 3.52 mins.

Testcase please?

-O

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Reuben Pasquini 2006-11-15 04:05:22 CallableStatement.setTimestamp bug
Previous Message Do, Leon (Leon) 2006-11-14 16:52:04 Re: help with front/backend datatype converting