Re: Need help to query with timestamp in C++

[Warren Young]

Kandy Wong wrote:
> 
> And what is the good connector (C++ to MySQL) to use?

MySQL++ (http://tangentsoft.net/mysql++/) has native Date, Time, and 
DateTime data types.  You can convert to these types implicitly:

	mysqlpp::DateTime dt = row["my_column"];

Row::operator[] doesn't return DateTime, it returns a stringish type, 
which can convert itself to lots of different C++ data types.  This is 
useful because the MySQL C API normally returns results in string form, 
so you need a natural way to convert these values to the native C++ 
types for processing.  In this particular case, it saves you from having 
to do the timestamp string parsing yourself.
-- 
Warren Young, maintainer of MySQL++