MariaDB 12.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

12.3.2-MariaDB-deb13

-- to_date() arrived in MariaDB 12.3, matching Oracle's spelling
select to_date('2026-01-31','YYYY-MM-DD') as parsed;

parsed

2026-01-31 00:00:00

-- to_char() has been there since 10.6
select to_char(date '2026-01-31','DD Month YYYY') as formatted;

formatted

31 January   2026