Minhaj Mimo Minhaj Mimo - 1 year ago 46
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

Answer Source

My solution was:

 $d = "Sunday 31 January 2016 - 00:55";
 $date = date("Y-m-d H:i",strtotime($d));
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download