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