Subtract date and time from another date and time, display difference.

[stangn99]

Hey guys,

How would I go about subtracting Today from a previous day to find the difference?

 

For example, I want to subtract TODAY from a previous date in my database, to determine if the difference is greater than 1 day.

 

Any ideas? I tried doing the subraction in TIMESTAMPS, but when I convert the date back to Y-m-d H:i:s, I got some weird year and time.

 

[johnny86]

<?php
// Create DateTime object with your timestamp
$date = DateTime::createFromFormat("Y-m-d H:i:s", '2010-02-15 15:16:17');
// Calculate the difference between your timestamp and "now"
$interval = $date->diff(new DateTime());
// Get the data stored in the DateInterval
echo $interval->format("Differernce is %d days, %h hours %i minutes and %s seconds.");
?>

[PFMaBiSmAd]

Supprizingly, there is a function to do this directly in your query - http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_datediff No slow php code is needed.

[stangn99]

Thanks for the information guys. I looked at the MYSQL page on DateDiff. I'm going to try this route first.

 

I'll post back if I hit any speed bumps.

 

Thanks again.

[stangn99]

Ok..so i'm stuck.

 

How would I use mysql's DATEDIFF to subtract a date in the database called 'expire' by the current date and time?

 

This doesn't work:

 

$result = mysql_query ("SELECT * FROM sample WHERE username = '$username' AND DATEDIFF('$today', 'expire'");

 

 

[johnny86]

Try:

$result = mysql_query("SELECT * FROM sample WHERE username = '$username' AND DATEDIFF(NOW(), expire) > 1");