Difference between two timestamps

[karandeep joshi123]

How to calculate time difference between two time stamps in terms of hours , minutes, seconds collectively

[RedSon]

How to calculate time difference between two time stamps in terms of hours , minutes, seconds collectively

You need to provide more information before we can help you. Or I can provide a general answer. You take the earlier time stamp and subtract if from the later time stamp.

[udaypawar]

Hi i too have the same problem.

I have a small forum system. And when user posts any article i am going to store it to the database along with current date. When Other users look at this article, I wants to show them the time lapsed after posting the article.

Means i wants subtract current time from the time stored in database and display the string such as "Article posted before 1 year 2 months 2 days 10 Hours 5 minutes and 3 seconds back".

Can any one help me please.

[debasisdas]

Use simple substraction and then go for conversions required if any.

[RedSon]

Use simple substraction and then go for conversions required if any.

Yes this is all pretty simple. and debasisdas said it correctly. All you need to do is subtract the first date from the second date. It is a trivial problem.

[JosAH]

Yes this is all pretty simple. and debasisdas said it correctly. All you need to do is subtract the first date from the second date. It is a trivial problem.

It is not if you want the output of the difference as asked for in post#3, i.e.
a 30 days difference would be less than a month if the last timestamp would be
mar-31-2007, but it would be a bit more than a month if the last timestamp would
be mar-01-2007.

That Gregorian calendar is a mess if you'd ask me ;-)

kind regards,

Jos

[RedSon]

It is not if you want the output of the difference as asked for in post#3, i.e.
a 30 days difference would be less than a month if the last timestamp would be
mar-31-2007, but it would be a bit more than a month if the last timestamp would
be mar-01-2007.

That Gregorian calendar is a mess if you'd ask me ;-)

kind regards,

Jos

The difference in time calculation is trivial. Trying to convert that difference in days months and years is a completely different matter. Best to use a Sidereal calendar.

[JosAH]

The difference in time calculation is trivial. Trying to convert that difference in days months and years is a completely different matter. Best to use a Sidereal calendar.

Erm, yes, that's what I said ;-)

kind regards,

Jos