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

[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 reserved for dates and timestamps and
the like, but how do I do this via the sqlite3_bind_* procedures?


I treat dates as a text field and have a C++ class that deals with all
the abstractions
of a date.