thanks.
--- On Thu, 6/12/08, Igor Tandetnik [EMAIL PROTECTED] wrote:
From: Igor Tandetnik [EMAIL PROTECTED]
Subject: Re: [sqlite] Date Selection
To: sqlite-users@sqlite.org
Date: Thursday, June 12, 2008, 7:51 AM
"Harold Wood" [EMAIL PROTECTED]
wrote in message news:[EMAIL PROTECTED]
"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
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
: [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';n
"Harold Wood" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> I have a table with a date column. I want to select * from
> TableA where DateCol Between '2008-06-10' and '2008-06-11';
> when i execute that query i get 0 records. when i remove the date
> selection i get all teh
I have a table with a date column. I want to select * from TableA where
DateCol Between '2008-06-10' and '2008-06-11'; when i execute that query
i get 0 records. when i remove the date selection i get all teh records.
what is the best way to query on date?
thanks
Woody
6 matches
Mail list logo