Sqlite uses an epoch based date like the Unix timestamp, but realised in
a 64 bit floating point number. It has a set of inbuilt functions to
process these timestamps. See date.c for full details.
Using the FP format of the date and time will work well in your application.
You can add date
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:
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
3 matches
Mail list logo