Re: [sqlite] Handling dates and timestamps via the C API

2005-10-31 Thread John Stanton
We use a TEXT field for dates and time and make it strictly ISO8601 and hence portable between storage methods. Jay Sprenkle wrote: I would like to know how I should handle dates and timestamps via the C API. I know that if I write an SQL insert statement, I have to use one of the forms

[sqlite] Handling dates and timestamps via the C API

2005-10-31 Thread Arjen Markus
Hello, I would like to know how I should handle dates and timestamps via the C API. I know that if I write an SQL insert statement, I have to use one of the forms reserved for dates and timestamps and the like, but how do I do this via the sqlite3_bind_* procedures? Regards, Arjen