"a load of tables that have a column named 'date'"....sounds a bit like a bagful of tables rather than a database. you should consider storing dates in provided database native type suitable. storing dates in text fields assures problematic records.
the hardest line to type correctly is: stty erase ^H