[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 fields, in the

[sqlite] Re: baffled by dates

Chris Fonnesbeck wrote: On 6/4/07, P Kishor <[EMAIL PROTECTED]> wrote: There is no "DATE" format in SQLite. Wow, thanks. So, why does this table creation work then, and not give an error? CREATE TABLE PIT_manatees(Manatee_Log INTEGER, Name text, First_Capture date, Recovered date, Coast