Re: Partition by Date Column

[Jake Peavy]

Edwin DeSouza Wrote:
-------------------------------------------------------
> Partition by Date Column:
>
> One of the most common usage of Partitioning is to
> partition
> by Date:
> - per Year, or
> - per Month, or
> - per Week, or
> - per Day.
>
> This blog entry shows how to handle this
> requirement using
> MySQL 5.1.
>
> http://mikaelronstrom.blogspot.com/2006/07/partiti
> on-by-date-column_115211159472825345.html


Does this mean that the functions QUARTER(), MONTH() or WEEK() (for instance) cannot be utilized by the partition optimizer? They do return integer values, but they weren't mentioned in either the blog post or your new partitioning article.

TIA,
-jp