How to find date differences in php

Question

Possible Duplicate:
PHP calculate person's current age

I want to find the persons age.

 $time=$row['date_of_birth'];
 $date=explode("-", $time);//gets the date birth from the database and puts it into an array
 $a=getdate();//gets todays date
 $diff_date= gregoriantojd($a["mon"],a["mday"],a["year"] ) - gregoriantojd(date[1],date[2],date[0]);//subtracts the differences between the dates, this is returned in seconds..

The question is whether this is the way to do it? and how do I convert the seconds and convert them to years (as an integer)?!

EDIT: I think that the last line should be this:

 return floor($diff_date /60*60*24*365);

return floor($diff_date /60*60*24*365); should the last line be that? — WithFlyingColors, Nov 10 '11 at 08:59

score 3 · Answer 1 · edited Nov 10 '11 at 09:00

3

Just try with strtotime (converts date string into timestamp):

$time = strtotime($row['date_of_birth']);
$age  = date('Y', $time - time());

echo 'age: ' . $age;

edited Nov 10 '11 at 09:00

Wesley van Opdorp

14,888
4
41
59

answered Nov 10 '11 at 08:55

hsz

148,279
62
259
315

will it give me an integer or a decimal? – WithFlyingColors Nov 10 '11 at 09:00
@WithFlyingColors It will give you an integer value. – hsz Nov 10 '11 at 09:02

score 1 · Answer 2 · answered Nov 10 '11 at 09:13

1

If $time is supposed to be unix timestamp

$time=$row['date_of_birth'];
$date1 = new DateTime($time);
$date_diff = $date1->diff(new DateTime(), true);
$age = $date_diff->y;

answered Nov 10 '11 at 09:13

Peter

69
3

score 0 · Answer 3 · answered Nov 10 '11 at 08:57

0

I think you can make use of the date_diff function in PHP.

answered Nov 10 '11 at 08:57

Damodaran

10,882
10
60
81

dude, I want to see if my way works – WithFlyingColors Nov 10 '11 at 08:59
1

if you want to see if your way works then run it and see? If not then try these answers that have been given to you. – martincarlin87 Nov 10 '11 at 09:12

score 0 · Answer 4 · answered Nov 10 '11 at 09:49

1st question: The question is whether this is the way to do it?

No. The function gregoriantojd (per the manual entry here) returns a value in days, not seconds. I like the date_diff conversion that Piotr gives the best.

2nd question: how do I convert the seconds and convert them to years (as an integer)?!

Well, if you were starting with a number of seconds (which you aren't) then your second formula would be mostly correct, but of course it wouldn't account for leap-years. So for anyone older than 4, or at least 8, it would be off for one or more days around their birthday. Usually on their birthday is a pretty important time to get their age correct.

How to find date differences in php

4 Answers4