"Will Leshner" <[EMAIL PROTECTED]> wrote: > 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. >
SQLite never has to figure out if the value in a field is a date or a time. There is no way for it to determine this. -- D. Richard Hipp <[EMAIL PROTECTED]>
