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 your date strings and convert them back and forth, manipulate them, etc. Once again, see the link on working with dates on the SQLite wiki.
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 text)