mysql does not seem to support the TIME type

[zcmaye]

No description provided.

[zcmaye]

CREATE TABLE test_datetime
(
    id INT PRIMARY KEY AUTO_INCREMENT,
    fdate DATE NOT NULL,
    ftime TIME NOT NULL,
    fdate_time DATETIME NOT NULL
);

execution query.

sqlpp::mysql::connection db(config);
for(const auto& row : db(sqlpp::select(sqlpp::all_of(tb)).from(tb).unconditionally())) 
{
      std::cout << row.id << " " << row.fdate << " " << row.ftime << " " << row.fdateTime << std::endl;
}

Bad, wrong.

[build] C:\Program Files (x86)\sqlpp11\include\sqlpp11/data_types/time_of_day/result_field.h(46): error C2039: "_bind_time_of_day_result": not is "sqlpp::mysql::char_result_t"  a memeber.
[build] C:\Program Files (x86)\sqlpp11\include\sqlpp11/mysql/char_result.h(44): note: see also “sqlpp::mysql::char_result_t”  statement

I checked mysql/char_result.h really don't have _bind_time_of_day_resul function.

help me,thanks!

[rbock]

Thanks for the report. I added the missing functions plus respective tests.

Hope this helps?

[zcmaye]

All right, thank you

Thanks for the report. I added the missing functions plus respective tests.

Hope this helps?

All right, thank you

[rbock]

Thanks for the confirmation.