Hello,

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.

If not, I had the idea to use UNIX timestamps for my date column. So
I've only integers and could select and convert them in my C code.

regards
Andreas

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to