mysql 8 date truncate to quarter code example

Example 1: disallowed function mysql to_date()

mysql> SELECT STR_TO_DATE('18,05,2009','%d,%m,%Y');
+--------------------------------------+
| STR_TO_DATE('18,05,2009','%d,%m,%Y') |
+--------------------------------------+
| 2009-05-18                           | 
+--------------------------------------+
1 row in set (0.00 sec)

Example 2: disallowed function mysql to_date()

SELECT STR_TO_DATE('18,05,2009','%d,%m,%Y');