Feature Request

Is your feature request related to a problem? Please describe:

Describe the feature you'd like:

MySQL Doc:
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_dayofmonth
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_last-day
TiDB implementation:
https://github.com/pingcap/tidb/blob/f0d83522692cc196b6ad8eeb1e6ea650a5a88667/expression/builtin_time.go#L1236
https://github.com/pingcap/tidb/blob/f0d83522692cc196b6ad8eeb1e6ea650a5a88667/expression/builtin_time.go#L7214

Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy: