timezone dilemma - Mailing list pgsql-general

From Fran Fabrizio
Subject timezone dilemma
Date
Msg-id 3.0.5.32.19981007152307.00944810@mail.primary.net
Whole thread Raw
List pgsql-general

Hi everyone,

I am in the central time zone but the server which is running pg is in the
eastern time zone.  What I need is that when I make a query to the
database, i want it to return the dates adjusted to central time zone.  Has
anyone done this before?  The postgresql user's guide makes a passing
reference to a 'set timezone' SQL statement but I can't find any other docs
on it at all.  PG is running on a redhat linux system.

My entire hockey team thinks everything on the schedule starts one hour
later than it actually does because of this problem. =)  I could just
subtract one from the hour, except some of our games start at 11pm, so that
becomes 00:00 the next day, and if i subtract one, I've got a game starting
at the -1 hour on the day after it's really happening. =)

Any ideas?

Thanks,
Fran


pgsql-general by date:

Previous
From: tom@swing.citiscape.com
Date:
Subject: Re: [GENERAL] Row Nums
Next
From: Jun Kuwamura
Date:
Subject: [pgsql-jp 5574] Re: Is array_iterator.c work? (fwd)