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

Reply via email to