flighttime field on database

[liberie]

Hello

Do anyone know why the field flighttime on table phpvms_schedules, is float instead of varchar

this is giving me some problems with fuel calculations where some short flight that I added with 00:40 minutes does get recorded at the database as 0.4 the only "solution" I found was use 00:45 which gets 0.45

Thanks

[Nabeel]

Use the flighttime_stamp column, that's a proper timestamp column. That flighttime column is left over from before.

[liberie]

strange I can't find this column

on which table is it ?

Thanks

[Nabeel]

In the pirep table.

Edit: Oh, you're looking at schedules, you'll have to do something like this:

SEC_TO_TIME(SUM(TIME_TO_SEC(flighttime)))

I have to add the flighttime_stamp column to that table.

[liberie]

Yep I'm using schedules table

since http://forum.phpvms.net/index.php?topic=1584.0 was made for it

and it's pretty handy for our pilots

if you will add this column to schedule table I could wait and rewrite np

Thanks a lot for your time