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 simpler way. RBS _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users