Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.14, 10.5.9
-
None
-
Mac OS, Debian Linux
-
Unexpected results
Description
STR_TO_DATE cannot handle German monthnames:
MariaDB [(none)]> set lc_time_names="de_DE";
|
Query OK, 0 rows affected (0.000 sec)
|
|
|
MariaDB [(none)]> select version();
|
+--------------------+
|
| version() |
|
+--------------------+
|
| 10.5.9-MariaDB-log |
|
+--------------------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [(none)]> select str_to_date(date_format("2010-04-01","%e. %M %Y"), "%e. %M %Y");
|
+-----------------------------------------------------------------+
|
| str_to_date(date_format("2010-04-01","%e. %M %Y"), "%e. %M %Y") |
|
+-----------------------------------------------------------------+
|
| 2010-04-01 |
|
+-----------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [(none)]> select str_to_date(date_format("2010-03-01","%e. %M %Y"), "%e. %M %Y");
|
+-----------------------------------------------------------------+
|
| str_to_date(date_format("2010-03-01","%e. %M %Y"), "%e. %M %Y") |
|
+-----------------------------------------------------------------+
|
| NULL |
|
+-----------------------------------------------------------------+
|
1 row in set, 1 warning (0.000 sec)
|
|
|
MariaDB [(none)]> show warnings;
|
+---------+------+--------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+--------------------------------------------------------------------+
|
| Warning | 1411 | Incorrect datetime value: '1. März 2010' for function str_to_date |
|
+---------+------+--------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [(none)]> set lc_time_names="de_DE";
|
Query OK, 0 rows affected (0.000 sec)
|
|
|
MariaDB [(none)]> select str_to_date(date_format("2010-06-01","%e. %M %Y"), "%e. %M %Y");
|
+-----------------------------------------------------------------+
|
| str_to_date(date_format("2010-06-01","%e. %M %Y"), "%e. %M %Y") |
|
+-----------------------------------------------------------------+
|
| NULL |
|
+-----------------------------------------------------------------+
|
1 row in set, 1 warning (0.000 sec)
|
Attachments
Issue Links
- causes
-
-
- In Progress
-