Daniel Cohen Gindi wrote:
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!
Sqlite uses a floating point column for date and time (timestamp).
There is a set of date functions built in to handle dates. You could
say: ... WHERE date > julianday('2007-12-13');
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
