logo       

Re: [GENERAL] timezone incompatibility: msg#00211

db.postgresql.jdbc

Subject: Re: [GENERAL] timezone incompatibility

Barry Lind wrote:
>
> OK, I found the bug in the jdbc code. It was treating a date coming
> from the server without timezone information as being in the local
> timezone instead of being in GMT. I will fix this over the weekend.

For "timestamptz" aka TIMESTAMP WITH TIME ZONE if it doesn't have a time
zone then it is GMT. If it is "timestamp" aka TIMESTAMP WITHOUT TIME
ZONE then they all are in the local time zone.

Does the JDBC driver let you distinguish between all of the cases?

- Thomas

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx





<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise