[MDEV-38584] TO_DATE: NLS_DATE_LANGUAGE=VIETNAMESE does not parse values which work in Oracle - Jira

XML

Word

Printable

The one-line test case is also attached as a file, in case JIRA corrupts the string.

Oracle
SELECT TO_DATE('15 tháng tư 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=VIETNAMESE') AS x FROM DUAL;

X
15-APR-24

bb-12.3-MDEV-19683-to_date f45636ea81a5a02444833e993e47c262ed52f384
MariaDB [test]> SELECT TO_DATE('15 tháng tư 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=VIETNAMESE') 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 tháng tư 2024' for function to_date \|
+---------+------+---------------------------------------------------------------------+
1 row in set (0.000 sec)

is caused by

MDEV-19683 Add support for Oracle TO_DATE()

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.