Re: get date/ datetime from database

[Peter Brawley]

Connector/C++ returns datetime values as %Y-%m-%d %H:%M:%S strings so you need something like ...

time_t String2time_t( const string& strDateTime ){
tm t;
strptime( strDateTime.c_str(), "%F %T", &t );
return mktime(&t);
}

time_t jt = String2time_t( (string) res->getString("columnName") );

which returns SQLstring, convert it to std::string before passig it on.