I'm at a complete loss about how to work with dates in SQLite. The
documentation doesnt seem to be helping me. I have a table with some date
fields, in the proper yyyy-mm-dd format:
sqlite> select First_Capture from PIT_manatees limit 5;
1997-6-17
1998-5-6
1997-6-24
1998-5-6
2000-3-15
however, it does not respond properly to comparisons to dates:
sqlite> select First_Capture from PIT_manatees where First_Capture<2000-1-1
limit 5;
sqlite>
this doesnt work either:
sqlite> select First_Capture from PIT_manatees where
First_Capture<date('2000-1-1') limit 5;
sqlite>
note that these columns are in the 'date' format.
How does one extract years, months, dates from tables in SQLite? The
'extract' function also seems not to work.
Any help most appreciated.
