TO_DATE: Basque localization is incompatible with Oracle

SELECT TO_CHAR(DATE '2024-04-15','DD MONTH YYYY','NLS_DATE_LANGUAGE=BASQUE') AS x FROM DUAL;

X

15 APIRILAK 2024

SELECT TO_DATE('15 apirilak 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=BASQUE') AS x FROM DUAL;

X

15-APR-24

MariaDB [test]> SELECT TO_DATE('15 apirilak 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=BASQUE') AS x FROM DUAL;

+------+

| x    |

+------+

| NULL |

+------+

1 row in set, 1 warning (0.001 sec)

MariaDB [test]> show warnings;

+---------+------+-------------------------------------------------------------------+

| Level   | Code | Message                                                           |

+---------+------+-------------------------------------------------------------------+

| Warning | 1411 | Incorrect datetime value: '15 apirilak 2024' for function to_date |

+---------+------+-------------------------------------------------------------------+

1 row in set (0.001 sec)

MariaDB [test]> SELECT TO_DATE('15 apirila 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=BASQUE') AS x FROM DUAL;

+---------------------+

| x                   |

+---------------------+

| 2024-04-15 00:00:00 |

+---------------------+

1 row in set (0.001 sec)

SELECT TO_DATE('15 apirila 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=BASQUE') AS x FROM DUAL

               *

ERROR at line 1:

ORA-01843: An invalid month was specified.