Hi,

I don't know much about the date-api. But the calender module uses the date_sql function to calculate the actually date if you configured a default time zone other than +0000. But the SQL generated by this function tries to add an interval of the correspondinf ofset to the timestamp as text. I am not sure if mysql can handle implicit conversation from text to timestamp. But at least PostgreSql requires an explicit cast. I provided a patch which applies an explicit cast.

Regards
wall_unit

CommentFileSizeAuthor
date-timestamp-cast.patch392 byteswall_unit

Comments

karens’s picture

karens commented
Status: Active » Closed (won't fix)

I'm not making changes to the 5.1 version. I'm officially recommending you move to the 5.2 version now. If you have problems in that version you can check for existing issues or add new ones. Feature requests are now getting posted to the D6 version to be back-ported to 5.2.

This problem doesn't apply to 5.2.