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

[Claude Mally]

When I change the syntax of the query to cast DATE to STRING,

SELECT name, owner, species, sex, CAST(birth as char) as birth_string, CAST(death as char) as death_string FROM pet;

The result Columns have no name, only STRING TYPE and string values such as "1999-03-30 00:00:00". Am I doing something wrong?