SQL Data type error

[Muzab]

Hello guys!

I have a problem with SQL Data for participants which is not being displayed correctly. I need to show the date & time (2016-04-16T16:22:32.604Z) which is a QDateTime and it shows itself up as "00:54:36.848" & a few Participant tags which are in hex value format and thus a QString but it is displayed as an integer.
I create my table in the ":memory" and the table code is as follows

qry.prepare("CREATE TABLE IF NOT EXISTS participant ("
                "participant_id INTEGER PRIMARY KEY,"
                "firstname VARCHAR(10),"
                "lastname  VARCHAR(20),"
                "participant_tag  VARCHAR(20)"
                "participant_time  TIMESTAMP"
              ")");

This is how I am writing to the table

QSqlQuery qry;
    qry.prepare("insert into participant(firstname, lastname, participant_tag, participant_time)"
                " values(:firstname,:lastname, :participant_tag, :participant_time)");
    qry.bindValue(":firstname", firstname);
    qry.bindValue(":lastname", lastname);
    qry.bindValue(":participant_tag", participant_tag);
    qry.bindValue(":participant_time", participant_time);

This is how I am displaying in the QTableView

QStandardItemModel *model = new QStandardItemModel(station1data.size(), 2,this);
   model->setHorizontalHeaderItem(0, new QStandardItem(QString("participant_id")));
   model->setHorizontalHeaderItem(1, new QStandardItem(QString("participant_tag")));
   model->setHorizontalHeaderItem(2, new QStandardItem(QString("participant_time")));
   int n = 0;
   foreach(msg_station1data d, station1data) {
       QStandardItem *item = new QStandardItem(QString(d.participant_id));
       model->setItem(n,0,item);
       item = new QStandardItem(QString(d.participant_tag));
       model->setItem(n,1,item);
       item = new QStandardItem((d.participant_time).toString("hh:mm:ss.zzz"));
       model->setItem(n,2,item);
       ++n;

Any help suggestion is appreciated (Thanks!)

[SGaist]

Hi,

For the date part, you are currently seeing what you are asking for (i.e. your format string).Take a look at the .toString funtion call.

For the hex part, can you show an example ?

[Muzab]

Thats true but I want "16:22:32.604Z" as I want to plot this later. The hex value that i send is like "a2b3c124d" but i get it back as integer value "1" "2" "3" for the first second and third values received but not the actual HEX values.

[SGaist]

Then store the QDateTime value and create a small QStyledItemDelegate to show the date the way you want it.

How are you storing the hex values in the first place ?

[Muzab]

I store the HEX in the table as follows:

 "participant_tag  VARCHAR(20)"
 "participant_time  TIMESTAMP"

[Muzab]

@SGaist said:

Then store the QDateTime value and create a small QStyledItemDelegate to show the date the way you want it.

Is there any reason for this ? can't i just display it otherwise as a string ?

[SGaist]

You are writing that you want to show it like 2016-04-16T16:22:32.604Z but later re-use it in another format. So either you store the QDateTime object and so you can re-use it and format it the way you want it when you want it. Or you store a string version of it and you'll have to re-do the conversion plus formatting later.

[Muzab]

Strangely this works
"participant_time VARCHAR(20)"

But should't this be working for the TIMESTAMP data-type too?.

[SGaist]

What does work ?