Example: an all day date for "2011-11-18" with the timezone "-2:00", then the date value saved in the database is "2011-11-17 22:00:00". When creating a relative filter in views for dates with greater than or equal to "now", the result is empty if the relative value for "now" is "2011-11-18": this occurs if I try to filter for dates set to today.

The SQL in the views debug shows: (DATE_FORMAT(STR_TO_DATE(field, '%Y-%m-%dT%T'), '%Y-%m-%d') >= '2011-11-18')

So one half of this should be converted to according to the timezone set in Drupal. My question is which half and where? or is this Views problem (latest dev used)?

Comments

fluffy’s picture

fluffy commented
Priority: Normal » Minor

When I changed in the field settings the "Time zone handling" to "UTC", then it works as expected. Is this the intended behaviour?

karens’s picture

karens commented
Status: Active » Closed (cannot reproduce)

There have been some recent commits that would affect this. Try the latest dev code. If there is still a problem I will need details on how to reproduce (details about how the view is configured and how the date field you are using is configured.)