On 8/4/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Adding DATE and TIMEINTERVAL types to SQLite would require an incompatible file format change. And it would go against the basic philosophy of SQLite.
I wonder if it might not be useful to be able to ask SQLite if a value is a date or time. I'm assuming that at some point SQLite has to figure out if a value in a field is a date or time, and perhaps that logic could be exposed as an API call somehow.