flighttime field on database

phpVMS Legacy Support (v2/v5)
1

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

2

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

3

strange I can’t find this column

on which table is it ?

Thanks

4

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.

5

Yep I’m using schedules table

since 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