Postgres Pro
Downloads
Home   >   mailing lists

Re: How to? Timestamp with timezone. - Mailing list pgsql-general

From Andre Lopes
Subject Re: How to? Timestamp with timezone.
Date
Msg-id 18f98e681003091407h64f0d565ud58543d6941e572c@mail.gmail.com
Whole thread Raw
In response to Re: How to? Timestamp with timezone.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: How to? Timestamp with timezone.  (John R Pierce <pierce@hogranch.com>)
Re: How to? Timestamp with timezone.  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Tree view
It is possible to do this in a shared database server?
 
Best Regards,


 
On Tue, Mar 9, 2010 at 9:54 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Andre Lopes <lopes80andre@gmail.com> writes:
> I have a database in a US based Server. I need to get a TIMESTAMP with the
> PORTUGAL time. How can I do this?

Try AT TIME ZONE, or just temporarily change the timezone setting.

                       regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to? Timestamp with timezone.
Next
From: John R Pierce
Date:
Subject: Re: How to? Timestamp with timezone.