I have the following table CREATE TABLE Sighting ( SightingId integer PRIMARY KEY AUTOINCREMENT NOT NULL, SpeciesId integer, LocationId integer, SightingDate date, Note nvarchar(100) );
and the following insert INSERT INTO Sighting (SpeciesID,LocationID,SightingDate,Note) VALUES (3005,22,'2/26/2008','New Note') the insert works EXCEPT the date keeps coming in as NULL! What am I doing wrong? Thanks Lonnie -- View this message in context: http://www.nabble.com/Insert-date-tp16895860p16895860.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users