Re: help with front/backend datatype converting - Mailing list pgsql-jdbc

On Fri, 5 Jan 2007, Do, Leon (Leon) wrote:

> Leon-it is actually a bug in the class.  The server could possibly sends
> a timezone in 'hhmm' format and the class treats the entire 4 digits as
> number of hours which is totally incorrect.  I already provided the
> quick fix so it won't take too much effort to put it in the load.  If
> you tell me the direction then I can add it in the load so you don't
> have to spend extra effort.
>

Please demonstrate how it is possible to generate a timezone in this
format.  I can't seem to do it:

jurka=# set timezone='Asia/Tehran';
SET
jurka=# select now();
                now
----------------------------------
  2007-01-05 22:56:26.065258+03:30


Kris Jurka