I am new user of sqlite
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?
Please give me a sample example to insert and retrive the table with dates using vb.net
Also tell me how to get date values from datareader.
I have written the fillowing code
Dim dblrepr As Double = CType(dr.GetDouble(23), Double)
Dim dlocal As DateTime = DateTime.FromOADate(dblrepr).ToLocalTime
but giving error :- specific cast is not valid.