timezone dilemma

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