On Nov 22, 2007 3:16 PM, Andrew Maclean <andrew.amaclean@gmail.com> wrote:
> I have a problem in that dates are stored as UTC in my dataase. I.e. without
> timezone.
>
> What I want to do: is to get this date from the server and add the server's
> current time zone to it. Then I will present a list of dates and times to
> the user in their time-zone. How can I do this? I have been trying to get
> the timezone from now() and adding it but I can't see how.
>
> Of course this doesn't account for daylight saving.
Does this help?
http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT