Work out average time
Posted: Tue Jun 21, 2005 8:22 am
Say i have a DB with 2 fields
start_time
end_time
both these contain UNIX timestamps.
i want to work out the average number of seconds between start_time and end_time.
Is it possible within one query, or will i need to do some calculation in php?
Ta
start_time
end_time
both these contain UNIX timestamps.
i want to work out the average number of seconds between start_time and end_time.
Is it possible within one query, or will i need to do some calculation in php?
Ta