Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
N/A
-
None
Description
|
Oracle |
SELECT TO_DATE('15 април 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=''CYRILLIC SERBIAN''') AS x FROM DUAL; |
|
|
X
|
15-APR-24
|
|
bb-12.3-MDEV-19683-to_date f45636ea81a5a02444833e993e47c262ed52f384 |
MariaDB [test]> SELECT TO_DATE('15 април 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=''CYRILLIC SERBIAN''') 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 април 2024' for function to_date | |
+---------+------+---------------------------------------------------------------------+ |
1 row in set (0.000 sec) |
In MariaDB, it requires months in latin:
MariaDB [test]> SELECT TO_DATE('15 april 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=''CYRILLIC SERBIAN''') AS x FROM DUAL; |
+---------------------+ |
| x |
|
+---------------------+ |
| 2024-04-15 00:00:00 |
|
+---------------------+ |
1 row in set (0.001 sec) |
Attachments
Issue Links
- is caused by
-
MDEV-19683 Add support for Oracle TO_DATE()
-
- In Testing
-
- relates to
-
MDEV-38520 TO_DATE: Basque localization is incompatible with Oracle
-
- Confirmed
-