QSqlQuery and rounding off of data

[ShamusVW]

I have created a QSqlQuery to access a MySQL database.
When I run the query against the database, it rounds to required 2 digits, however the QSqlQuery returns 17 digits.
Any idea why this happens? I don't necessarily want to format the returned value, I want the database to return the formatted value, hence I include it in the query.

This is my query... (and following that is my function to access the database)
The 2 fields returned are supposed to be 0.26 & 0.46.
Instead I get 0.26000000000000001 & 0.46000000000000002

SELECT ROUND(c1/TIME_TO_SEC(TIMEDIFF(now(), '2016/05/16 06:00:00')),2) AS p1,
ROUND(c2/TIME_TO_SEC(TIMEDIFF(now(), '2016/05/16 06:00:00')),2) AS p2 FROM
(SELECT SUM(TIME_TO_SEC(TIMEDIFF(cycle_end, cycle_start))) AS c1 FROM daq_iv.dae005_cycles WHERE pallet_no = 1 AND cycle_start >= '2016/05/16 06:00:00')t1,
(SELECT SUM(TIME_TO_SEC(TIMEDIFF(cycle_end, cycle_start))) AS c2 FROM daq_iv.dae005_cycles WHERE pallet_no = 2 AND cycle_start >= '2016/05/16 06:00:00')t2

QStringList DBMySQL::getData(QString queryString)
{
    QStringList sl;
    if (m_DBOpen) {
        QSqlQuery query(QSqlDatabase::database(m_ConnectionName)); //create QSqlQuery object using given database
        query.setForwardOnly(true); //sets mode to traverse forwards only through result set, potentially improves speed
        if (!(query.exec(queryString))) {  //if succesful, returns true else false
            sl << query.lastError().text(); //error executing query, return the error
        }
        else {
            int fieldCount = query.record().count();
            while (query.next()) {
                QString str("");
                for (int i = 1; i <= fieldCount ; ++i) { //return each row as a comma deliminated string
                    if (i == fieldCount)
                        str = str + query.value(i-1).toString();
                    else
                        str = str + query.value(i-1).toString() + "|";
                }
                sl << str;
            }
        }
    }
    else {
        sl << "DB not open";
    }
    return sl;
}

QStringList DBMySQL::getData(QString queryString)
{
    QStringList sl;
    if (m_DBOpen) {
        QSqlQuery query(QSqlDatabase::database(m_ConnectionName)); //create QSqlQuery object using given database
        query.setForwardOnly(true); //sets mode to traverse forwards only through result set, potentially improves speed
        if (!(query.exec(queryString))) {  //if succesful, returns true else false
            sl << query.lastError().text(); //error executing query, return the error
        }
        else {
            int fieldCount = query.record().count();
            while (query.next()) {
                QString str("");
                for (int i = 1; i <= fieldCount ; ++i) { //return each row as a comma deliminated string
                    if (i == fieldCount)
                        str = str + query.value(i-1).toString();
                    else
                        str = str + query.value(i-1).toString() + "|";
                }
                sl << str;
            }
        }
    }
    else {
        sl << "DB not open";
    }
    return sl;
}

To copy to clipboard, switch view to plain text mode 

[anda_skoa]

My guess would be that "ROUND" just rounds the value and does not convert it to a string.
So the type of the value is still a floating point number and the values you get are the closest possible to the rounded values.

Again assuming that ROUND does not create a string, then that is missing from your query.

Cheers,
_

[ShamusVW]

That makes sense.
I formatted it in my code anyway now, so doesn't matter anymore.
Thanks for the reply.