[Resolved] Difference between dates?

dreams4000

Hey all,

Quick question. Is there a way to show a difference between dates to get a day difference? For example if I have two timestamps.. one is for Oct 10, 2004, 1:00pm the other is for Oct 11, 2004, 2:00pm... I would like the output to say 1 day and 1hr since that is the difference between the two. Any ideas? Thanks all!

SD-Syndicate

Hi Dreams4000,

Im not sure but what I would prolly do is use the time("U"); to give you a integer of the signup date for example might be

1097523875

Then get the current time using that code which now is

1097549123

then I think you`d subtract the last by the current time which would make it

1097523875-1097549123 = 25248 seconds

Then divide that by 60, Which should give you it in minutes 420.8, Then divide it by 60 again which would be 7.01 hours, Share that by 24 which should give you if you use round() 0.3 days.

but Im sure theres prolly a simpler way. 🙂

dreams4000

Hey Syndicate,

Your method seems logical and probably will work. I am hoping someone out there has an idea for what to do with two timestamps though as that is what the program is running off of right now🙁 If I cant figure out any other way though, I will probably have to go with how you mention and just change the setup. Thanks for your help with this!

Anyone have any ideas for timestamp differences?

dreams4000

I have it figured out. I ran this mysql statement and just echoed its results and it seems to work fine.

$sql2 = "SELECT ((UNIX_TIMESTAMP(checked_in) - UNIX_TIMESTAMP(checked_out))/86400) FROM sometable WHERE id = $id";