I was wondering if anyone could help, I am trying to get the date in my View to order in ascending order. Every time I try it keeps coming up with an error stating the syntax is wrong.
The code of the view is below:
ALTER VIEW `MyFlights` AS SELECT
DATE_FORMAT(`Flights`.`FlightDate`,'%d-%b-%Y') AS `FlightDate`,
`Flights`.`Departed`,
`Flights`.`Arrived`,
`Flights`.`Airline`,
`Flights`.`FltNo`,
`Flights`.`ACReg`,
`Flights`.`Aircraft`
FROM `Flights` WHERE 1
How can I get the date in order?