Re: help with front/backend datatype converting

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