Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: How to? Timestamp with timezone.
Date
Msg-id 29462.1268171689@sss.pgh.pa.us
Whole thread Raw
In response to How to? Timestamp with timezone.  (Andre Lopes <lopes80andre@gmail.com>)
Responses Re: How to? Timestamp with timezone.  (Andre Lopes <lopes80andre@gmail.com>)
List pgsql-general
Tree view 
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: Jeff Davis
Date:
Subject: Re: Postgres GIS Question
Next
From: Andre Lopes
Date:
Subject: Re: How to? Timestamp with timezone.