Hello Igor the create table statement: CREATE TABLE Items ( ID INT NOT NULL PRIMARY KEY ASC, SubCatId INT NOT NULL, Description VARCHAR(60) NOT NULL, LastUnitPrice NUMERIC(6,2) DEFAULT 0.0, AvgUnitPrice NUMERIC(6,2) DEFAULT 0.0, MinUnitPrice NUMERIC(6,2) DEFAULT 0.0, LastPurchaseDate DATETIME, LastQtyPurchase NUMERIC(6,2) DEFAULT 0.0, PurchaseUnit VARCHAR(20), NumTimesPurchased INT DEFAULT 0, NeedIt BIT DEFAULT 0, FOREIGN KEY (SubCatId) REFERENCES Subcategory(ID) );
--- On Wed, 6/11/08, Igor Tandetnik <[EMAIL PROTECTED]> wrote: From: Igor Tandetnik <[EMAIL PROTECTED]> Subject: Re: [sqlite] Date Selection To: sqlite-users@sqlite.org Date: Wednesday, June 11, 2008, 10:45 PM "Harold Wood" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have a table with a date column.&nbsp; I want to select * from > TableA where DateCol Between '2008-06-10' and '2008-06-11';&nbsp; > when i execute that query i get 0 records. when i remove the date > selection i get all teh records. &nbsp; > what is the best way to query on date? How do you store your dates? Show the output of this statement: select DateCol, typeof(DateCol) from TableA limit 1; Igor Tandetnik _______________________________________________ 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
