On Thu, May 01, 2003 at 13:28:52 -0700,
Ron St-Pierre <rstpierre(at)syscor(dot)com> wrote:
>
> In both cases the time is returned as UTC. Is there any way I can
> configure the databases to return local times/dates? These apps are
> already built and I want to avoid changing all of the coded queries. Can
> anyone help?
You can use AT TIME ZONE to get output from timestamptz in a particular
timezone. As long as your app can adjust the query based on the timezone
the end user wants, you should be able to do what you want.