如果日期和时间不是TIMESTAMPDIFF格式那么如何用mysql查找间隔？

Question

A jQuery script is used to pick date and time. The format is "Sunday 31 January 2016 - 00:55". I want to run mysql to find date-time interval. But it is not in TIMESTAMPDIFF format. So how to find the interval?

I used this script for picking date & time http://www.jqueryscript.net/time-clock/Pretty-Date-Time-Picker-Plugin-For-Bootstrap-Material.html

Answer 1

My solution was:

 $d = "Sunday 31 January 2016 - 00:55";
 $date = date("Y-m-d H:i",strtotime($d));