On Mon, Sep 10, 2007 at 08:34:55AM -0700, novnov wrote: > Your explanation of now() and localtime() is good...but localtime() to > postgres acting as a web app db, wouldn't it just return the local time as > far as the server is concerned? It will return localtime relative to whatever you've configured the timezone to be. Have your webapp execute "set timezone = 'foo'" at the beginning of the session and everything will flow from there. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
