[sqlite] Re: baffled by dates

Thanks to everyone for their help and advice. I think I get it now. Cheers, cf On 6/4/07, Chris Fonnesbeck <[EMAIL PROTECTED]> wrote: 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

Re: [sqlite] baffled by dates

On 6/4/07, P Kishor <[EMAIL PROTECTED]> wrote: There is no "DATE" format in SQLite. Dates are stored as strings. The only formats SQLite knows and understands are TEXT, REAL, INTEGER, BLOB, and NULL (see the link on datatypes). On the other hand, there are built-in functions that can act on

[sqlite] baffled by dates

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 -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,

[sqlite] extracting and comparing dates

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 -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,