TIMEDIFF
Posted: Wed Nov 15, 2006 6:00 pm
$sql = "SELECT in_date, in_time, out_date, out_time, TIMEDIFF(out_time,in_time) FROM XXX";
Just wondering for the TIMEDIFF funciton, I can only put in one column name for time in and out or I can put in the date as well ???
i tried something like TIMEDIFF(out_date.out_time,in_date.in_time)
it doesnt seems to be working
The following data is in my table
in_date in_time out_date out_time
10/11/06 00:02 10/11/06 00:02
10/11/06 00:02 10/11/06 00:03
15/11/06 15:41 16/11/06 09:34
Just wondering for the TIMEDIFF funciton, I can only put in one column name for time in and out or I can put in the date as well ???
i tried something like TIMEDIFF(out_date.out_time,in_date.in_time)
it doesnt seems to be working
The following data is in my table
in_date in_time out_date out_time
10/11/06 00:02 10/11/06 00:02
10/11/06 00:02 10/11/06 00:03
15/11/06 15:41 16/11/06 09:34