mysql string to date

Question

I got error when i try to change string to date.

mysql> select STR_TO_DATE('03.05.2010 00:00','%d.%m.%Y %h:%i');
+--------------------------------------------------+
| STR_TO_DATE('03.05.2010 00:00','%d.%m.%Y %h:%i') |
+--------------------------------------------------+
| NULL                                             |
+--------------------------------------------------+
1 row in set, 2 warnings (0,00 sec)

how can i convert to date from '03.05.2010 00:00' ? Thanks

min and seconds are always 00:00?

McNets
– McNets

2017-03-10 11:32:20 +00:00
Commented Mar 10, 2017 at 11:32 — McNets
– McNets, Commented Mar 10, 2017 at 11:32
just to add for answer - %h it from 01 to 12, %H - 00-23

a_vlad
– a_vlad

2017-03-10 11:40:09 +00:00
Commented Mar 10, 2017 at 11:40 — a_vlad
– a_vlad, Commented Mar 10, 2017 at 11:40

McNets · Accepted Answer · 2017-03-10 11:46:59Z

2

Use %H instead of %h.

select STR_TO_DATE('03.05.2010 00:00','%d.%m.%Y %H:%i');

Or, if HH:MM are always 00:00 you can use date part only:

select STR_TO_DATE('03.05.2010 00:00','%d.%m.%Y');

Check it here: http://rextester.com/CCPKR29919

As @a_vlad has pointed out on his comments, %H is used to format hours as 00..23 and %h as 01..12.

Have a look at DATE_FORMAT() on MySql docs.

edited Mar 10, 2017 at 11:46

answered Mar 10, 2017 at 11:36

McNets

24k11 gold badges52 silver badges91 bronze badges

Add a comment |

Stack Exchange Network

mysql string to date

1 Answer 1

Your Answer

Hot Network Questions

mysql string to date

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions