Hi,
I dont think it's needed to go into to much details here but the query:
SELECT CONCAT(Airports.IATA, ' - ', Airports.Name) AS ArrivingFrom,
ADDTIME(FlightData.TimeStamp,
SUBTIME(FlightData.Enroute,DATE_FORMAT(SUBTIME(FlightData.TimeStamp,FlightData.ActDepTime),'%H:%i:%s')))
AS
05, 2005 4:09 PM
Subject: where and dates
Hi,
I dont think it's needed to go into to much details here but the
query:
SELECT CONCAT(Airports.IATA, ' - ', Airports.Name) AS ArrivingFrom,
ADDTIME(FlightData.TimeStamp,
SUBTIME(FlightData.Enroute,DATE_FORMAT(SUBTIME