Re: [sqlite] Insert date

2008-04-25 Thread Federico Granata
On Linux I get SQLite version 3.5.6 Enter ".help" for instructions sqlite> CREATE TABLE Sighting ( ...> SightingIdinteger PRIMARY KEY AUTOINCREMENT NOT NULL, ...> SpeciesId integer, ...> LocationIdinteger, ...> SightingDate date, ...> Note nvarchar(100)

Re: [sqlite] Insert date

2008-04-25 Thread Simon Davies
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? > >

Re: [sqlite] Insert date

2008-04-25 Thread Scott Baker
Scott Baker wrote: > lrjanzen wrote: >> I have the following table >> CREATE TABLE Sighting ( >> SightingIdinteger PRIMARY KEY AUTOINCREMENT NOT NULL, >> SpeciesId integer, >> LocationIdinteger, >> SightingDate date, >> Note nvarchar(100) >> ); >> >> and the

Re: [sqlite] Insert date

2008-04-25 Thread Scott Baker
lrjanzen wrote: > I have the following table > CREATE TABLE Sighting ( > SightingIdinteger PRIMARY KEY AUTOINCREMENT NOT NULL, > SpeciesId integer, > LocationIdinteger, > SightingDate date, > Note nvarchar(100) > ); > > and the following insert > INSERT INTO

Re: [sqlite] Insert date

2008-04-25 Thread Emilio Platzer
try inserting year/month/day Emilio > > I have the following table > CREATE TABLE Sighting ( > SightingIdinteger PRIMARY KEY AUTOINCREMENT NOT NULL, > SpeciesId integer, > LocationIdinteger, > SightingDate date, > Note nvarchar(100) > ); > > and the following