Is your feature request related to a problem? Please describe.
mysql supports the date functions:yearweek(),week(),makedate(), but these functions cannot be found in doris.
Describe the solution you'd like
mysql> select yearweek('2021-6-1');
+----------------------+
| yearweek('2021-6-1') |
+----------------------+
| 202122 |
+----------------------+
mysql> select week('2021-6-1');
+------------------+
| week('2021-6-1') |
+------------------+
| 22 |
+------------------+
mysql> select makedate(2021, 100);
+---------------------+
| makedate(2021, 100) |
+---------------------+
| 2021-04-10 |
+---------------------+