mysql> SELECT PARTITION_DESCRIPTION FROM `information_schema`.`PARTITIONS` where table_name='test_TST' order by partition_ordinal_position desc;

+-----------------------+

| PARTITION_DESCRIPTION |

+-----------------------+

| '2013-05-01' |

| '2013-04-01' |

+-----------------------+

2 rows in set (0.00 sec)



mysql> SELECT str_to_date(`PARTITION_DESCRIPTION`,'%Y-%m-%d') FROM `information_ schema`.`PARTITIONS` where table_name='test_TST' order by partition_ordinal_pos ition desc;

+-------------------------------------------------+

| str_to_date(`PARTITION_DESCRIPTION`,'%Y-%m-%d') |

+-------------------------------------------------+

| NULL |

| NULL |

+-------------------------------------------------+

2 rows in set, 2 warnings (0.00 sec)



mysql> mysql> desc `inforation_schema`.`PARTITIONS`;TIONS`

ERROR 1146 (42S02): Table 'information_ schema.PARTITIONS' doesn't exist

mysql> desc `information_schema`.`PARTITIONS`;

+-------------------------------+---------------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------------------------------+---------------------+------+-----+---------+-------+

| TABLE_CATALOG | varchar(512) | NO | | | |

| TABLE_SCHEMA | varchar(64) | NO | | | |

| TABLE_NAME | varchar(64) | NO | | | |

| PARTITION_NAME | varchar(64) | YES | | NULL | |

| SUBPARTITION_NAME | varchar(64) | YES | | NULL | |

| PARTITION_ORDINAL_POSITION | bigint(21) unsigned | YES | | NULL | |

| SUBPARTITION_ORDINAL_POSITION | bigint(21) unsigned | YES | | NULL | |

| PARTITION_METHOD | varchar(18) | YES | | NULL | |

| SUBPARTITION_METHOD | varchar(12) | YES | | NULL | |

| PARTITION_EXPRESSION | longtext | YES | | NULL | |

| SUBPARTITION_EXPRESSION | longtext | YES | | NULL | |

| PARTITION_DESCRIPTION | longtext | YES | | NULL | |

| TABLE_ROWS | bigint(21) unsigned | NO | | 0 | |

| AVG_ROW_LENGTH | bigint(21) unsigned | NO | | 0 | |

| DATA_LENGTH | bigint(21) unsigned | NO | | 0 | |

| MAX_DATA_LENGTH | bigint(21) unsigned | YES | | NULL | |

| INDEX_LENGTH | bigint(21) unsigned | NO | | 0 | |

| DATA_FREE | bigint(21) unsigned | NO | | 0 | |

| CREATE_TIME | datetime | YES | | NULL | |

| UPDATE_TIME | datetime | YES | | NULL | |

| CHECK_TIME | datetime | YES | | NULL | |

| CHECKSUM | bigint(21) unsigned | YES | | NULL | |

| PARTITION_COMMENT | varchar(80) | NO | | | |

| NODEGROUP | varchar(12) | NO | | | |

| TABLESPACE_NAME | varchar(64) | YES | | NULL | |

+-------------------------------+---------------------+------+-----+---------+-------+

25 rows in set (0.01 sec)

mysql> show warnings;

+---------+------+-------------------------------------------------------------------+

| Level | Code | Message |

+---------+------+-------------------------------------------------------------------+

| Warning | 1411 | Incorrect datetime value: ''2013-05-01'' for function str_to_date |

| Warning | 1411 | Incorrect datetime value: ''2013-04-01'' for function str_to_date |

+---------+------+-------------------------------------------------------------------+

2 rows in set (0.00 sec)