Comments - Datetime format YYYYMMDD hh:mm:ss.fff
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
You might be able to use STR_TO_DATE() to make your conversion easier.
It looks like STR_TO_DATE('20210315', '%Y%m%d') might do the trick.
You'd then have to CONCAT() it back together with the time portion of the string.