Timezone into/out of function

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.

Responses

Browse pgsql-novice by date

  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?