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
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)
HTH
Martin
NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] 06/25/02 04:40PM