We have just setup our first PostgreSQL system. We have a vendor product
that connects via ODBC. That vendor product needs to talk in a different
timezone than our database server is at. How can you specify a timezone
to use through ODBC?


Jed S. Walker

Interesting question. It makes me wonder, is ODBC supposed to be a smart
pipe or a dumb pipe.

So I ask, it the timestamp being sent, a simple one, with no indication
of timezone.

The postgreSQL has a syntax for timestamps with timezones
hh:mm:ss+/-hh:mm eg (10:30:21-08:00, 09:35:17+05:00). see PostgreSQL
User's guide in the documentation as PDF - just look up datatypes Date
and Times.

Could the client do the translation to UTC/GMT, and that be what is
transmitted.

It seems that the areas DBMSs vary most are DDL (data definition
lanaguage) and DateTime signification.



Walker, Jed S wrote:

> We have just setup our first PostgreSQL system. We have a vendor product
> that connects via ODBC. That vendor product needs to talk in a different
> timezone than our database server is at. How can you specify a timezone
> to use through ODBC?
>
>
> Jed S. Walker
>


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

To configure a server for a default timezone, see the PostgreSQL admin
guide for the PostgreSql configuration file, the TIMEZONE parameter.



Walker, Jed S wrote:

> We have just setup our first PostgreSQL system. We have a vendor product
> that connects via ODBC. That vendor product needs to talk in a different
> timezone than our database server is at. How can you specify a timezone
> to use through ODBC?
>
>
> Jed S. Walker
>


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq