I: am trying to use STR_TO_DATE but why does this return null?

Question

INSERT INTO covernote (issue_date) VALUES ( STR_TO_DATE ( '13-May-13','%Y-%m-%d') );

Because May is not %m see https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format — P.Salmon, Mar 02 '21 at 07:24

score 2 · Answer 1 · answered Mar 02 '21 at 07:26

Because May is not %m see https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format - %b for abbreviated month or %M for full month name

+--------------------------------------+--------------------------------------+--------------------------------------+
| STR_TO_DATE( '13-May-13','%Y-%m-%d') | STR_TO_DATE( '13-May-13','%Y-%b-%d') | STR_TO_DATE( '13-May-13','%Y-%M-%d') |
+--------------------------------------+--------------------------------------+--------------------------------------+
| NULL                                 | 2013-05-13                           | 2013-05-13                           |
+--------------------------------------+--------------------------------------+--------------------------------------+
1 row in set, 1 warning (0.106 sec)

It's a pity you picked may as a representative sample..

score 1 · Answer 2 · answered Mar 02 '21 at 07:27

1

Per the documentation on date formatting, %m is the code for "Month, numeric (00..12)".

You are looking for %M, which represents "Month name (January..December)"

answered Mar 02 '21 at 07:27

samuei

688
2
14

i want to convert 13-May-13 to mysql date format which is Y-m-d – ortan Mar 02 '21 at 07:29
ok i got your point .It worked . thanks alot – ortan Mar 02 '21 at 07:30
Happy to help! Sorry if I wasn't clear enough. – samuei Mar 02 '21 at 07:32
1

Or possibly %b. – Strawberry Mar 02 '21 at 08:09

I: am trying to use STR_TO_DATE but why does this return null?

2 Answers2