> SQLite does not have a datetime type. Your declaration of a field as > "Date datetime NOT NULL" is equivalent to a declaration of "Date BLOB NOT > NULL" as far as SQLite is concerned.
Correction: a declaration of a type of "date" has the default NUMERIC affinity and is equivalent to "Date NUMERIC NOT NULL". That means that if you store something that looks like a number, it will be converted to an appropriate numeric type (integer or, if it cannot be represented as an integer -- because it has a decimal point or exceeds the magnitude for a 64-bit integer -- to a float). Data which cannot be converted to a NUMERIC type will be stored as presented (in the case shown, as text). --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
