Problem finding Number of Days between 2 dates

[system]

Hi,
This Solution might help…to calculate the number of hours between two dates…May need to change a bit to get seconds…

120×120 10.4 KB

How can I calculate the number of hours between two dates? The best way to do it (and the fastest) is to do it in the database. If you simply subtract the two days, you will get a number in the format D.T, where “D” is the number of days, and “T” is the fraction of days in decimal form. In other words, day 2 and noon minus day 1 at midnight will yield 1.5 as the result. Take this number and multiply by 24, that gives you the number of hours. Take the decimal portion of that and divide …

Ravi

---

ravi_prk (BOB member since 2004-09-03)