On Nov 22, 2007 3:16 PM, Andrew Maclean <andrew.amaclean@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
