Look at:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
Alternatively, you could use the c library's time() or gettimeofday()
and store the result in an INTEGER column (which in sqlite can hold
64-bit values, if you need the full resolution from gettimeofday).
In either case,
Hello,
I would like to use the sqlite3_bind_* functions to bind data to a
TIMESTAMP column.
With regular SQL I can use the following command:
INSERT INTO TABLE (completed) VALUES(date('now'));
The data('now') function returns the current date.
What is the correct method in the C API to have
2 matches
Mail list logo