From: | "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com> |
---|---|
To: | "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Timezone into/out of function |
Date: | 2005-05-19 19:29:58 |
Message-ID: | 41669DC6FE3B80449A33A4DD46DB370A0D1EE837@entcoexch15.broadband.att.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I have two functions that have a timestamp wtz passed to and return
timestamps wtz in a refcursor. The catch is that I need the timezone on the
timestamp passed out to match the timezone of the timestamp passed in. I
realize I can set the timezone parameter before making the call, but I'm
concerned that if a user calls it with a timezone that is different than the
timezone parameter the date they get won't match the timezone they
requested.
Is there a way I can specify timezone as a parameter and force the
timestamps in the where and select clauses to use that timezone? (without
having to set the timezone parameter in the session)
Thanks
Jed.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-05-19 21:48:15 | Re: Trigger Function Problem |
Previous Message | Pierre Couderc | 2005-05-19 18:42:51 | How to deal with large object? |