MySQL Forums
Forum List  »  Partitioning

Re: When can we have range partitioning to_hour?
Posted by: Peter Gulutzan
Date: September 28, 2006 03:12PM

The following is currently possible:

create table tn5 (s1 timestamp)
partition by range (to_days(s1)*24+hour(s1))
(partition p1 values less than (1));

But MySQL may remove this support due to
Bug#18198 Expressions are allowed as partition functions

We'll know "soon".

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: When can we have range partitioning to_hour?
2895
September 28, 2006 03:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.