Re: Difference between dates

[davido]

Can't this be solved almost entirely within an SQL query?

[aaron_baugher]

Yes. The OP's code doesn't seem to match his question, since it doesn't do any subtracting, but MySQL can give you the difference between two dates:

SELECT id, DATEDIFF(lastlogin, dateadded) FROM order_details;