you can fetch the date using getString. Connector/C++ doesn't have Date/Time support, still. We decided to postpone it and the plans are to add, at later stage, Datetime support by using Boost::Datetime library.
Using any type of String requires date parsing. I'm assuming that the C++ API doesn't provide any type of date parsing, which makes comparisons on the returned values really difficult. Therefore, using getString is not really a viable solution at all.
As long as you add the Boost dependency cleanly it could work nicely. I'd just be careful of not forcing users of the C++ API to pull in too much of Boost.
So, it seems that I'll need to hack up my SQL 99 compliant selects to be MySQL specific in the short term. I really don't understand why you didn't just return date columns as seconds since epoch UTC using unsigned ints. This seems the best method and most C++ libraries support this concept. The API would look like this:
unsigned int date = resultSet->getDate();
Then you could do comparisons and math on the values.