[sqlite] Making SQL queries with date conditions?

[Daniel Cohen Gindi]

Hi guys!

 

Is there any way to make SQL queries, with the WHERE clause containing
dates? I mean [WHERE col > 05/12/2007] or such?

It just that I have noticed that there's no DATE datatype.

If there's no way, is it easy to override the text comparing operators (<=,
>=, <, >) ?

 

Thanks a lot!