Hi Andreas,
I like to save a date for each row in my database. Later I would
select the rows with a query:
SELECT *
FROM Store_Information
WHERE Date BETWEEN 'Jan-06-1999' AND 'Jan-10-1999'
Is there a date data type in sqlite? I've not found it in the docs.
Store dates in this format: YYYY-MM-DD such as 2007-12-02
Use dates like this:
select *
from Store_Information
where Date between '1999-01-06' and '1999-01-06'
Some documentation is here:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
Tom
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
