Scott Baker wrote: > 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.
I guess I should include a URL: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions -- 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
