[sqlite] Insert date

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 Sighting

Re: [sqlite] Insert date

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 insert INSERT

Re: [sqlite] Insert date

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 Sighting

Re: [sqlite] Insert date

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 following insert INSERT

Re: [sqlite] Insert date

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

Re: [sqlite] Insert date

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) ... );