where and dates

2005-05-05 Thread Chris Knipe
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

Re: where and dates

2005-05-05 Thread Chris Knipe
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