Hi Chris, I think you've seen Rich Shepard's reply, and emails crossed.
But just in case you didn't: The sqlite date/time functions require input dates to contain a preceeding zero for month and day-of-month where needed to make them two digits. E.g., '2007-6-4' bad '2007-06-04' good Regarding: CREATE TABLE PIT_manatees(Manatee_Log INTEGER, Name text, First_Capture date, Recovered date, Coast text) Remember that SQLITE does not prevent you from putting most ANYTHING as a data type. E.g., CREATE TABLE manatees ( myData BIG_GREY_SLIPPERY_BEASTIES_TYPE); Works quite fine. Be sure to see: http://www.sqlite.org/datatype3.html -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Fonnesbeck Sent: Monday, June 04, 2007 3:24 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] baffled by dates 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) ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------