Date subtraction

[guilty_spark]

I'm having difficulty with mySQL date operations.

I have a start date (in table s_emp), and need to subtact this from today's date in order to formulate a 'length of service' value in years.

Any help?

Thanks

-- GS --

[barand]

Something like

SELECT name, (TO_DAYS(CURDATE()) - TO_DAYS(start_date))/365 AS service_years FROM s_emp
ORDER BY service_years DESC

[celon_php_master]

it is easy

let say ur database table date filed is in the timestamp fromat

$Today_date=date("Y-m-d");

$D1=substr($table_date_field,0,8);
$D2=substr($Today_date,0,8);

$Date_str_one=strtotime($D1);
$Date_str_two=strtotime($D2);
$no_of_dayz= ($Date_str_two-$Date_str_one)/(3600*24);

[danielsonchris]

Originally Posted by barand

Something like

SELECT name, (TO_DAYS(CURDATE()) - TO_DAYS(start_date))/365 AS service_years FROM s_emp
ORDER BY service_years DESC

The above code does not take into account leap years. You will want to use the DateDiff function or the DateAdd function. The DateAdd function allows for you to pass an "interval" in as a parameter. This will allow the function to perform a subtraction routine.

Regards,
Chris Danielson