subtract two dates and get an integer???

[SystemOverload]

I have a MySQL field 'orgDateAmended'

 

I need to obtain the number of days since the record was amended in PHP.

 

In plain english  [currentdate] - [orgDateAmended] = x  << i want 'x'

 

I have no issue retrieving the date in MySQL, I just need to know how to subtract the two once I have the orgDateAmended assigned to a PHP Variable.

 

Thanks.

[ignace]

SELECT now() - orgDateAmended AS x FROM table

[SystemOverload]

Is it not easier to do it in PHP with PHP functions?

[ignace]

Is it not easier to do it in PHP with PHP functions?

 

That actually doesn't matter but given you are retrieving the data from MySQL you might aswell do the conversion in your query so that you can start working with it in PHP

[SystemOverload]

Thanks

[SystemOverload]

Ok, I get an integer (74891990) from now()-date_amended, which I presumed was seconds, but with a date of 2009-08-27 23:22:18, now()-this date should result in approx  483,304.79 seconds (8055 mins or 134 hrs or 5.59 days). 

 

If 74891990 were seconds, it would result in 866 days, ie: way out.

 

Can someone explain why I'm getting this figure and give me a hint where I'm going wrong please.

 

Thanks

 

[Mark Baker]

What data type are you using for the orgDateAmended column in your table?

[SystemOverload]

A - DATETIME

B - Someone on another forum has provided the following solution:

 

UNIX_TIMESTAMP() - UNIX_TIMESTAMP(orgDateAmended) AS x

 

which appears to work just fine, unless you can see any issues with doing it this way?

 

Thanks