I use date column in Sqlite as text with format 'yyyy-mm-dd'.
Declared type is 'date' real type in 'text'.
After query i test result column type:
sqlite3_column_type(sqlite3_stmt*, int iCol) return SQLITE_TEXT
sqlite3_column_decltype(sqlite3_stmt*, int iCol) return 'date' only for
table column and NULL for computed column as max(date-column).
SQL function (and user function) can't return declared type of origin
column.
Can everyone add this feature?
Fabio
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------