Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group