Convert column (type TIME in Sqlite) to QTime

creasser

Hello,
is possible to somehow select TIME column from sqlite to pass it to QTimeEdit?

My current construction is pretty ugly:
ui->start_1->setTime(QTime::fromString(query.value(0).toString(), "hh:mm"));

it's because query.value(0) returns string type :-/

Is there any better way?

Thanks in advance
C.

raven-worx

shouldn't it return a QVariant instead of a string?
If i'm right, then please check the type of the QVariant.

creasser

yep, sry QVariant(String, "10:00") - something like that... but QTimeEdit.setTime()... can't handle that format

raven-worx

but if it would be of type QVariant::Time you just could call QVariant::toTime()
But if a string is returned your way from your first post is the only correct way. The plugin doesn't seem to preserve the type through the API.

creasser

which plugin do you mean?

btw, as I said, the column in sqlite is type of TIME therefore I expected the TIME type will be returned, when I call through QT something like "select myTime from myTable "

but as you can see, result is qvariant(string, "10:00") :-/

raven-worx

[quote author="creasser" date="1375280082"]which plugin do you mean?
[/quote]
i mean the Qt sqlite database plugin.

[quote author="creasser" date="1375280082"]
btw, as I said, the column in sqlite is type of TIME therefore I expected the TIME type will be returned, when I call through QT something like "select myTime from myTable "

but as you can see, result is qvariant(string, "10:00") :-/[/quote]
i know... thats why i said it seems that the plugin doesn't support it.

creasser

ah, yeah, thanks a lot

pure beginner at qt, you know... :)

raven-worx

no problem...everyone was at some point ;)