Check out the Date Module. It has a sub module called Date Views which gives you what you want: http://drupal.org/project/date

Check out the Date Module. It has a sub module called Date Views which gives you what you want: http://drupal.org/project/date.

The generated sql isn't pretty though. If you can use hook_views_query_alter instead you really should since you have better control over the result sql.