lrjanzen wrote: > 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?
The date/time documentation details all the formats that SQLite understands. You probably just want: YYYY-MM-DD. -- Scott Baker - Canby Telcom RHCE - System Administrator - 503.266.8253 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users