Re: How to? Timestamp with timezone.

[Andre Lopes <lopes80andre@xxxxxxxxx>]

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@xxxxxxxxxxxxx> wrote:

Andre Lopes <lopes80andre@xxxxxxxxx> 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