Is there any way with sqlite3_column_decltype (or otherwise) to get the
declared data type (as in the table create sql in SQLite_master) when it is
a simple expression such as max and min?
for example we have a table created like this:
create table1([integer_date] int_date)
and we do:
select max(integer_date) from table1
I would then like to get returned int_date, rather than integer.
The custom datatype int_date is needed for formatting purpose to tell the
app that receives
the data that the column holds dates as integers.
To do this in application code is not that simple, so I hope there is some
sqlite-users mailing list