Versions above just before 4.0 of MySQL can handle direct date math.

Try SELECT date_returned - date_paged FROM pagetable;

It'll work if you have values "date_returned" and "date_paged" in the table 
"pagetable" of course :o)



>>> "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> 06/25/02 04:40PM >>>
        I am working on a Call Log application, and need to calculate time.
For example, if a page is received at 12:00, the page is returned at 12:10,
and the call is resolved at 14:30...  I need to be able to calculate the
time to return the page, and also the time to resolve the call.  I am not
sure if PHP provides a function to handle date/time math.  I know that MySQL
can add and subtract a fixed interval to a date/time, but I am not sure if
it can deal with math involving a pair of date/time values.  Thanks in

Scott Nipp
Phone:  (214) 858-1289
Web:  http:\\

PHP Database Mailing List (
To unsubscribe, visit: 

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to