C++: MySQL xdevapi crashes when inserting data (throws no meta-data found error)
I’m trying to insert some data in a MySQL table using the C++ Xdevapi. The following code for inserting something in a table unsurprisingly works:
Facing an issue to convert timestamp to date in MySqlX.XDevAPI
I am trying to convert TimeStamp to Date format for easier comparisons to fetch records from my
MySqlX db but when I try to query it like this
DbDoc docData = new DbDoc(new { _startDate = startDate.Value.ToString("yyyy-MM-dd"), _endDate = endDate.Value.ToString("yyyy-MM-dd") }); collection.Find("DATE_FORMAT(TimeStamp, '%Y-%m-%d') >= :_startDate AND DATE_FORMAT(TimeStamp, '%Y-%m-%d') <= :_endDate").Bind(docData).Execute()