Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
-
Not for Release Notes
Description
The commit comment says that AD_DOT format element is supported, but it doesn't seem to be the case:
|
bb-12.3-MDEV-19683-to_date f45636ea81a5a02444833e993e47c262ed52f384 |
MariaDB [test]> SELECT TO_DATE('A.D. 2026-01-08','A.D. YYYY-MM-DD') AS x; |
+------+ |
| x |
|
+------+ |
| NULL | |
+------+ |
1 row in set, 1 warning (0.001 sec) |
|
|
MariaDB [test]> show warnings;
|
+---------+------+------------------------------------------------------------------+ |
| Level | Code | Message | |
+---------+------+------------------------------------------------------------------+ |
| Warning | 1411 | Incorrect datetime value: 'A.D. 2026-01-08' for function to_date | |
+---------+------+------------------------------------------------------------------+ |
1 row in set (0.001 sec) |
|
Oracle PL/SQL |
SELECT TO_DATE('A.D. 2026-01-08','A.D. YYYY-MM-DD') AS x; |
|
|
X
|
08-JAN-26
|
AD works:
MariaDB [test]> SELECT TO_DATE('AD 2026-01-08','AD YYYY-MM-DD') AS x; |
+---------------------+ |
| x |
|
+---------------------+ |
| 2026-01-08 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
-