try inserting year/month/day Emilio
> > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users