MySQL Forums
Forum List  »  Connector/C++

Re: Connector c++ 8 converting field Value for DATE to time_t
Posted by: Claude Mally
Date: August 23, 2021 08:56AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Connector c++ 8 converting field Value for DATE to time_t
301
August 23, 2021 08:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.