Minhaj Mimo Minhaj Mimo - 9 months ago 29
MySQL Question

If date and time is not in TIMESTAMPDIFF format then how to find the interval with mysql?

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 Source

My solution was:

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