Re: [sqlite] How to bind DATE and TIME values

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,

Re: [sqlite] sqlite3_errCode and error handling

I submitted a bug with a similar problem a while back: http://www.sqlite.org/cvstrac/tktview?tn=1366 the bug was closed with this comment by drh: "SQLITE_CORRUPT gets returned when you call sqlite3_reset() or sqlite3_finalize(). This is unfortunate, I know. We should have designed the API