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.

[sqlite] Handling dates and timestamps via the C API

[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