in file "includes/date_api_argument_handler.inc" and "includes/date_api_filter_handler.inc",
there is a line in function pre_query():

$this->offset = in_array($this->date_handler->granularity, array('hour', 'minute', 'sec')) ? NULL : 0;

where the granularity check value 'sec' is wrong and should be 'second'.
This typo exists in 6.x-2.8 and made some of my views return wrong results after upgrading from 2.7 to 2.8

The typo would make argument and filter handlers to use UTC as timezone of query value when granularity is set to 'second',
where the correct way in 2.7 is to use default timezone of site (seems to be).
If downgrading to 2.7, the problem disappears. If fix the lines in 2.8, the problem disappears.
So the problem should be caused by the typo.

Comments

damienmckenna’s picture

Issue summary: View changes
Status: Active » Closed (won't fix)

Unfortunately the Drupal 6 version of this module is no longer supported.