[Bug]: whether can time type be acted as parition key?

### Is there an existing issue for the same bug?

- [X] I have checked the existing issues.

### Branch Name

main

### Commit ID

b2d8e4aefb0d7b3b3d7deb19a772c6bbfa973a9f

### Other Environment Information

```Markdown
- Hardware parameters:
- OS type:
- Others:
```

### Actual Behavior

MO:
mysql> create table t1 (d time) partition by range columns(d) ( partition p0 values less than ('2000-01-01 10:10:10'), partition p1 values less than ('2020-01-01 20:10:10'));
Query OK, 0 rows affected (0.05 sec)

MYSQL:
mysql> create table t1 (d time) partition by range columns(d) ( partition p0 values less than ('2000-01-01 10:10:10'), partition p1 values less than ('2020-01-01 20:10:10'));
ERROR 1654 (HY000): Partition column values of incorrect type

### Expected Behavior

_No response_

### Steps to Reproduce

```Markdown
create table t1 (d time) partition by range columns(d) ( partition p0 values less than ('2000-01-01 10:10:10'), partition p1 values less than ('2020-01-01 20:10:10'));
```

### Additional information

_No response_