From: | Fran Fabrizio <fran(at)primary(dot)net> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | timezone dilemma |
Date: | 1998-10-07 20:23:07 |
Message-ID: | 3.0.5.32.19981007152307.00944810@mail.primary.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | David Hartwig | 1998-10-07 20:34:15 | Re: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF) |
Previous Message | tom | 1998-10-07 18:45:16 | Re: [GENERAL] Row Nums |