I have created a calendar view for "activities" that I defined by adding a CCK date field to the typical content type. I use granularity month and the timezone Europe/Paris (site).
I understand that entering an "Activity" with "start date" = "end date" and time = 00:00 describes a whole day event. This works for almost any date.
However if the date is the first of a month during the summer time period the activity is not appearing in the view.
Looking at the case of 1st May, I see that the date stored in the database is: 2009-04-30T22:00:00. This looks like the correct UTC time.
I also see that the where clause in the select statement is:
((node.status <> 0) AND (node.type in ('activity')))
AND ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'),
SEC_TO_TIME(3600)), '%Y-%m') <= '2009-05'
AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date.field_date_value2, '%Y-%m-%dT%T'),
SEC_TO_TIME(3600)), '%Y-%m') >= '2009-05'))
adding only one hour to the date stored in the database (i.e. the time difference for the winter time). And, of course, the 1st of any month during summer time is not selected.
Is it realy a bug or have I done something wrong?
I attach the view and the content type exports.