2. PHPRunner General questions
  3. [SOLVED]  REPORT DAYS CALCULATION
This topic is locked
[SOLVED]

 REPORT DAYS CALCULATION

 		2/27/2012 10:21:18 AM
PHPRunner General questions
C
 ckapote author

I HAVE A REPORT AND I NEED TO CALCULATE THE NUMBER OF DAYS BETWEEN NOW AND A FIELD NAMED hr_services_joining_date WHEN I OPEN THE REPORT.

FILED TO STORE NUMBER OF DAYS IS hr_services_total_amount .
pls advise provide php code.
Sergey Kornilov admin 2/27/2012

Check DATEDIFF() function in MySQL for this purpose:

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_datediff
C
 		ckapote author 2/27/2012



Check DATEDIFF() function in MySQL for this purpose:

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_datediff



thanks i would appreciate a real example
Sergey Kornilov admin 2/27/2012

Here it is:

SELECT DATEDIFF('2010-11-30 23:59:59','2010-12-31')