Calculating date difference

lhadley91 · #1 (**permalink**) 10-12-11, 04:33

Firstly, I should state I am a major newb. I'm trying to calculate the difference between two dates in a table. The table has two fields 'qdate', and 'currdate' set up as timestamps. All I'm trying to do is figure out the difference between the two dates in the fields.
I've tried timestampdiff with no luck. So now I'm trying it this way but I get the result 0. Am I missing something simple here?

PHP Code:


			
$result = mysql_query("SELECT *

FROM time");

$row = mysql_fetch_array( $result );



$currdate = $row[currdate];

$qdate = $row[qdate];



echo ($currdate - $qdate)

healdem · #2 (**permalink**) 10-12-11, 04:57

what did you try?
what difference are you looking for?
..days, hours, months....
MySQL :: MySQL 5.5 Reference Manual :: 11.7 Date and Time Functions
gives you lots of options.. I'd expect timediff would of more use to you

alternatively you could do the date calcualtions in PHP
PHP: Date/Time Functions - Manual

lhadley91 · #3 (**permalink**) 10-12-11, 16:02

Thanks for the link healdem I worked it out from your php link

I ended up making the field type an integer, inserting unix timestamps and then running this:

Quote:

$result = mysql_query("SELECT * FROM time");
$row= mysql_fetch_array( $result );

$a = (time() - $row['qdate']);
$b = '600';
if ($a > $b) {
mysql_query($ifquery);
echo updated;
}

Thanks for taking a look

Internet Services

Web Development

Digital Marketing

Consumer Tech