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 funtionality to Sqlite in your application interface.
For example we add a DATE and a DATETIME type and perform date and time
artihmetic.
Andreas Volz wrote:
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]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
