我想实现一个按时间分区的表，下面是我写的例子，其中 PARTITION p0 VALUES LESS THAN ('2008-07-04 02:35:27')这句有问题，如果按照其他的字段来分区就没有问题，mysql是不是不能按datetime格式的字段为条件进行分区？如果不能该如何实现？谢谢！下面是建表语句
CREATE TABLE `alarm_info_tab` (
`dtime` datetime NOT NULL,
`alarm_no` int(8) NOT NULL,
`alarm_level` int(1) NOT NULL,
`color_index` int(1) NOT NULL,
`server_name` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`process_name` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`desciption` varchar(600) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL
) PARTITION BY RANGE (dtime) (
PARTITION p0 VALUES LESS THAN ('2008-07-04 02:35:27')
);