Comments - Datetime format YYYYMMDD hh:mm:ss.fff

3 years, 9 months ago Jan Steinman

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.

 
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.