This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Converting datetime to new temporal format

Is there a way to convert a datetime value through date and time functions that returns a value in the new temporal format? It appears that all functions I've tested output in the "datetime /* mariadb-5.3 */" format when materialized in a view.

Answer Answered by Daniel Black in this comment.

This has been identified as a bug - MDEV-32063

Confirming this makes sense as the database where I identified this is running 10.6.5.

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.