The output from the query is as follows:
select NULL link, s.AIRCRAFT ID, a.MANUFACTURER||' '||a.MODEL||' ('||a.TAIL_NUMBER||')' NAME, null PARENT_ID, s.START_DATE ACTUAL_START, s.END_DATE ACTUAL_END from AIR_MASTER_SCHEDULE s, AIR_AIRCRAFT a where s.AIRCRAFT = a.ID
I see there is a Date Format in Gantt Setttings, but I'm not sure if this has any bearing as changing it does not seem to affect the outcome. Any Suggestions?
LINK ID NAME PARENT_ID ACTUAL_START ACTUAL_END - 1 Cessna 152 (02G) - 08/07/2012 10:00am 08/07/2012 12:00pm