Will, Thanks for the reply. Yes in version 2 I would do something like:
CREATE TABLE TEST (d DATE); And use the DATE returned in the column names (using the show datatypes pragma). >From the documentation, it appears that sqlite3_column_type returns one of five defined types, none of which is a date (obviously, as SQLite doesn't distinguish dates). Is there a way I can continue using the text-based data type (in addition to the new data type functionality)? Regards, Steve -----Original Message----- From: Will Leshner [mailto:[EMAIL PROTECTED] Sent: Friday, January 21, 2005 3:47 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] v2 -> v3 upgrade On Fri, 21 Jan 2005 14:30:01 -0000, Drew, Stephen <[EMAIL PROTECTED]> wrote: > However, with version 3 and its new data types, I can't seem to be > able to replicate this. It seems as though it will just be treated as > a numeric data type. Does anyone know how I can achieve the same functionality? I believe the "data type string" you are referring to in v2 is the user-defined column type, not the intrinsic type of the data itself. There is an API call for fetching the user-defined column type: int sqlite3_column_type(sqlite3_stmt*, int iCol);
