I had to restore a drupal 7 site from scheduled backup using backup & migrate. Since then I seem to have problem with date/timestamp.
I have a view (3.6) filtering on node created date with options between "today" and "tomorrow".
All users are in GMT+7 timezone.
It is now 18:01pm here and the sql query generated has:
node.created BETWEEN 1375959700-25200 AND 1375959700+61200
So "today" is current time instead of today at 00:00:00
Any suggestion ?