Convert Text to datetime

Jassim Rahma

Hi, I have below date text and I want to know how can I convert it to valid MySQL datetime which is yyyy-mm-dd HH:mm Nov 20 2015 10:51AM Nov 20 2015 10:16PM Nov 20 2015 10:01AM Nov 20 2015 8:43PM Nov 20 2015 8:04PM Nov 20 2015 5:49PM Nov 20 2015 5:38PM Nov 20 2015 5:23PM Nov 20 2015 5:03PM Nov 20 2015 4:57PM Nov 20 2015 2:10PM Nov 20 2015 1:51PM Nov 19 2015 12:24AM Nov 19 2015 11:56AM Nov 19 2015 11:32PM Nov 19 2015 11:27PM Nov 19 2015 10:15AM Nov 19 2015 10:12PM How can I do this please? Thanks, Jassim[^]

Technology News @ www.JassimRahma.com

NickPace

This should work: SELECT DATE_FORMAT(STR_TO_DATE('Nov 20 2015 10:51AM', '%b %d %Y %h:%i%p'), '%Y-%m-%d %H:%i'); #Returns 2015-11-20 10:51 SELECT DATE_FORMAT(STR_TO_DATE('Nov 20 2015 8:43PM', '%b %d %Y %h:%i%p'), '%Y-%m-%d %H:%i'); #Returns 2015-11-20 20:43

-NP Never underestimate the creativity of the end-user.

Mycroft Holmes

Wow doesn't MySQL have the convert function? SELECT CONVERT(DATETIME,'Nov 20 2015 8:43PM') Is the SQL Server method, so simples!

Never underestimate the power of human stupidity RAH

NickPace

It does have a CONVERT method but it won't work with that format of text dates. That was the first thing I tried.

-NP Never underestimate the creativity of the end-user.