On Linux I get SQLite version 3.5.6 Enter ".help" for instructions sqlite> CREATE TABLE Sighting ( ...> SightingId integer PRIMARY KEY AUTOINCREMENT NOT NULL, ...> SpeciesId integer, ...> LocationId integer, ...> SightingDate date, ...> Note nvarchar(100) ...> ); sqlite> INSERT INTO Sighting (SpeciesID,LocationID,SightingDate,Note) VALUES (3005,22,'2/26/2008','New Note'); sqlite> select * from Sighting; 1|3005|22|2/26/2008|New Note
-- [image: Just A Little Bit Of Geekness]<http://feeds.feedburner.com/%7Er/JustALittleBitOfGeekness/%7E6/1> Le tre grandi virtù di un programmatore: pigrizia, impazienza e arroganza. (Larry Wall). On Fri, Apr 25, 2008 at 6:20 PM, Simon Davies < [EMAIL PROTECTED]> wrote: > 2008/4/25 lrjanzen <[EMAIL PROTECTED]>: > > > > I have the following table > ... > > 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 > > > > On XP I get > > SQLite version 3.4.2 > Enter ".help" for instructions > sqlite> > sqlite> CREATE TABLE Sighting ( > ...> SightingId integer PRIMARY KEY AUTOINCREMENT NOT NULL, > ...> SpeciesId integer, > ...> LocationId integer, > ...> SightingDate date, > ...> Note nvarchar(100) > ...> ); > sqlite> > sqlite> INSERT INTO Sighting (SpeciesID,LocationID,SightingDate,Note) > ...> VALUES (3005,22,'2/26/2008','New Note'); > sqlite> select * from sighting; > 1|3005|22|2/26/2008|New Note > sqlite> > > What operating system, version, wrapper? > > Rgds, > Simon > _______________________________________________ > 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