search

phpvms / phpvms_v2

Virtual Airline Management (not maintained)
http://www.phpvms.net
BSD 3-Clause "New" or "Revised" License
41 stars 46 forks source link

MySQL's SEC_TO_TIME has a max of 839.X hours #23

Closed nabeelio closed 13 years ago

nabeelio commented 13 years ago

Instead of:

SEC_TO_TIME(SUM(TIME_TO_SEC(*)))

Use:

SUM(TIME_TO_SEC(*))

Then convert the time to HH:MM:SS in PHP. Convertions needed for: PilotStats, StatsData