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

Timezones and time/timestamp values in FE/BE protocol

From: Rene Pijlman <rene(at)lab(dot)applinet(dot)nl>
To: pgsql-hackers(at)postgresql(dot)org
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Timezones and time/timestamp values in FE/BE protocol
Date: 2001-09-09 18:28:15
Message-ID: kbbnpt0lf6iiom1jm42misb0mf3iol8287@4ax.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
I'm working on a problem in the JDBC driver that's related to
timezones.

How does PostgreSQL handle timezones in the FE/BE protocol
exactly?

When a client sends a time or timestamp value to the server via
the FE/BE protocol, should that be:
1) a value in the client's timezone?
2) a value in the server's timezone?
3) a value in a common frame of reference (GMT/UTC)?
4) any value with an explicit timezone?

And how should a time or timestamp value returned by the server
be interpreted in the client interface?

And how does this all depend on the timezone setting of the
server?

Regards,
René Pijlman <rene(at)lab(dot)applinet(dot)nl>

Responses

pgsql-hackers by date

Next:From: Oliver ElphickDate: 2001-09-09 19:16:00
Subject: Re: INHERIT
Previous:From: Hannu KrosingDate: 2001-09-09 18:23:57
Subject: Re: INHERIT

pgsql-jdbc by date

Next:From: Barry LindDate: 2001-09-09 19:51:10
Subject: Re: [HACKERS] Troubles using German Umlauts with JDBC
Previous:From: Rene PijlmanDate: 2001-09-09 14:46:30
Subject: Re: [HACKERS] Troubles using German Umlauts with JDBC

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