On Thu, Jun 12, 2008 at 5:50 AM, Harold Wood [EMAIL PROTECTED] wrote:
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)
Harold Wood [EMAIL PROTECTED]
wrote in message news:[EMAIL PROTECTED]
the create table statement:
LastPurchaseDate DATETIME,
You seem to be under impression there's a dedicated DATETIME type in
SQLite. This is not the case: it's just the nature of SQLite's manifest
typing
thanks.
--- On Thu, 6/12/08, Igor Tandetnik lt;[EMAIL PROTECTED]gt; wrote:
From: Igor Tandetnik lt;[EMAIL PROTECTED]gt;
Subject: Re: [sqlite] Date Selection
To: sqlite-users@sqlite.org
Date: Thursday, June 12, 2008, 7:51 AM
Harold Wood lt;[EMAIL PROTECTED]gt;
wrote in message news:[EMAIL
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?
nbsp;
thanks
Woody
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
;nbsp; );
--- On Wed, 6/11/08, Igor Tandetnik lt;[EMAIL PROTECTED]gt; wrote:
From: Igor Tandetnik lt;[EMAIL PROTECTED]gt;
Subject: Re: [sqlite] Date Selection
To: sqlite-users@sqlite.org
Date: Wednesday, June 11, 2008, 10:45 PM
Harold Wood lt;[EMAIL PROTECTED]gt;
wrote in message news:[EMAIL