MariaDB DATE_FORMAT

DATE_FORMAT(NOW(), '%Y-%m-%d')

2025-01-02

DATE_FORMAT(NOW(), '%Y. %c. %e')