The timestamps were entered as free text in a web form.

I hope that's the #1 thing on your to-do list (give the users a pulldown menu, or simply use localtime/gmtime)

You wanna handle SQL-esque type queries in a non-SQL way, you're gonna have to bend over backwards to do it.

You need to involve another database and create kinds of indexes.