[support] Trouble with Relative Times and Filtering a View

Earnie Boyd earnie at users.sourceforge.net
Tue Apr 10 13:18:18 UTC 2012


On Mon, Apr 9, 2012 at 9:41 PM, Shai Gluskin <shai at content2zero.com> wrote:
>
> I think what is going on is that "Now" is the server time (my server is in
> LA) and the Post date is in Eastern time.
>

mysql> SET GLOBAL time_zone = timezone;

http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html

You could add a db_query() to settings.php to modify the timezone value.

-- 
Earnie
-- https://sites.google.com/site/earnieboyd


More information about the support mailing list