One of my (many) tasks at my current position is to maintain a SQL Server database where a lot of the date times are stored as raw strings in various different

One of my (many) tasks at my current position is to maintain a SQL Server database where a lot of the date times are stored as raw strings in various different formats. If you're determined enough you can turn any datastore into a mess, though I suppose SQLite gives you less tools.