finding the average of timestamps
Moderator: General Moderators
finding the average of timestamps
How could I find the average of multiple timestamps? How about the average of time types? which would be easier?
Re: finding the average of timestamps
lobo78 wrote:How could I find the average of multiple timestamps?
Convert them to unix timestamp ([mysql_man]unix_timestamp[/mysql_man]), then compute the average, then convert the average back to the timestamp([mysql_man]from_unixtime[/mysql_man])
Doesn't make any difference whether you use timestamp or time types.lobo78 wrote: How about the average of time types? which would be easier?