conds
you'll get odd results when traversing daylight savings.
-Mike
- Original Message -
From: "Martin Clifford" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 25, 2002 1:47 PM
Subject: Re: [PHP-DB] Time difference questi
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
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
r, $minute, $second, $month, $day, $year??
>
> -Original Message-
> From: Lerp [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 15, 2002 8:46 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Time Difference
>
>
> Hi again. I have a date field in my mssql 7.0 db format :
Are you saying you got two different return values with the exact same input
values for $hour, $minute, $second, $month, $day, $year??
-Original Message-
From: Lerp [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 8:46 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Time Difference
Hi again. I have a date field in my mssql 7.0 db format : 2/14/2002
12:21:28 PM . I would like to know how to calculate the difference in
seconds between 2 such timestamps.
$starttime = mktime($hour, $minute, $second, $month, $day, $year); returns
:1013776613
endtime = mktime($hour, $minute, $s
