DATETIMEs are sorted alphabetically because they are stored as strings in the database. They should be sorted chronologically which will involve changing the type in the schema as well as making a method in AisDatabaseFasade to convert the format in the CSV files to the format needed in MySQL
lapost48
commented
8 years ago
DATETIMEs are sorted alphabetically because they are stored as strings in the database. They should be sorted chronologically which will involve changing the type in the schema as well as making a method in AisDatabaseFasade to convert the format in the CSV files to the format needed in MySQL