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: [email protected]
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]
-----------------------------------------------------------------------------
