calculate date

[flashfinger]

hi all

how i can calculate the date to get the age from date of birth ?

thks

[bradgrafelman]

Easiest way I can think of is to get the Unix timestamp of the birth date and divide the difference of it and the current Unix timestamp by the number of seconds in a day. You would then want to use [man]floor/man on the result to get an integer.

[flashfinger]

hi all

i find this usefull

//calculating age//

$age = $birth;
function age($age)
{
list($year,$month,$day) = explode("-",$age);
$year_diff = date("Y") - $year;
$month_diff = date("m") - $month;
$day_diff = date("d") - $day;

if($day_diff < 0 or $month_diff < 0)
{
$year_diff--;
}
return $year_diff;
}
$myage=age($age);
//end calculate the age//

hope usefull

[bogu]

Using a couple of IFs you can do it directly from mysql...[code=php]SELECT
IF(
YEAR(CURDATE())>YEAR(date),
IF(
MONTH(CURDATE())<MONTH(date),
YEAR(CURDATE())-YEAR(date)-1,
IF(
MONTH(CURDATE())=MONTH(date),
IF(
DAY(CURDATE())<DAY(date),
YEAR(CURDATE())-YEAR(date)-1,
YEAR(CURDATE())-YEAR(date)
),
YEAR(CURDATE())-YEAR(date`)
)
),

)

FROM table[/code]This will return the numbers of years ...

[bradgrafelman]

You can also do it directly in SQL using my method... it'd be much simpler, too:

SELECT
FLOOR( (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(birthday)) / (60*60*24*365) )
FROM myTable

[bogu]

bradgrafelman wrote:

You can also do it directly in SQL using my method... it'd be much simpler, too:

SELECT
FLOOR( (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(birthday)) / (60*60*24*365) )
FROM myTable

It`s ok ... if you don't care about the leap year?