Re: Connector c++ 8 converting field Value for DATE to time_t

[Claude Mally]

> Relational databases are not designed for, indeed are designed to prevent such under-the-hood data manipulation.

Indeed, there is some sort of abstraction level missing in the c++ connector library to bridge the gap between a Value and whatever c++ representation may be convenient for representing such a value for a given type, like DATETIME.

>> The result Columns have no name

> SELECT ..., CAST(birth as char) as birth_string will return the values with the aliased name `birth_string`.

using mysql console application, I get the proper name back indeed, but my application selecting CAST(field as char) as other_field produces a result row where column names for casted fields are empty strings "".