Hi,
I'd like to obtain the number of hours and minutes between two fields
datetime and I'm trying to proceed just like the documentation says.
SELECT ..., B.dthr_occurrence as open,
DATE_SUB(C.dthr_occurrence, INTERVAL B.dthr_occurrence
HOUR_MINUTE) AS during,
DATE_SUB(D.dthr_occurrence, INTERVAL B.dthr_occurrence
HOUR_MINUTE) AS late
FROM CALL A, OCCURRENCE B, OCCURRENCE C, OCCURRENCE D
WHERE A.COD_CALL = B.COD_CALL AND
A.COD_CALL = C.COD_CALL AND
A.COD_CALL = D.COD_CALL AND
A.COD_LINK = '$lnk' AND
B.DESC_OCCURRENCE = 'open' AND
C.DESC_OCCURRENCE = 'close' AND
D.DESC_OCCURRENCE = 'stop' AND
(B.DTHR_OCCURRENCE BETWEEN '$datef' AND '$datet')
But there is a problem. At the end this query returns a the correct result,
but all the
lines with the fields "during" and "late" in blank.
The function DATE_SUB is returning NULL and there isn't more examples.
Any idea about what to do?
[]s,
-----------------------------------------------------------
Felipe D. Ramalho
Estagi�rio - Datapuc - Suporte Tecnol�gico
+55 31 3249-7300
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
