In Qtableview convet julianday to Qdate

sharan

i have table in database which stores date in julianday ,
I use QSQLRelationaltablemodel for the tableview model
the table view displays the data in integer format so how i can i convert integer to Qdate in the qtableview

i can use QDate::FromJulianDay ( int jd ) but how to do it in qtableview
please reply

b1gsnak3

I am assuming something like this:

@
QDate asd = QDate::fromJulianDay(dateFromSqlTable);
QString dateInStringFormat = asd.toString();

QTableView *tbView = new QTableView();
// add wtv data you need. here you can add the data to your QAbstractItemModel

@

SGaist

Hi and welcome to DevNet,

One way to do that is to use a "delegate":http://qt-project.org/doc/qt-4.8/qstyleditemdelegate.html that simply translate your integer to a QDate and from the QDate to string.

Hope it helps

sharan

dates are only present in single column not whole table,
is there any way to change single column only using delegates

SGaist

Something like "this":http://qt-project.org/doc/qt-4.8/qabstractitemview.html#setItemDelegateForColumn ?

sharan

thanks SGaist

napajejenunedk0

"This":http://qt-project.org/forums/viewthread/7428 is the solution.

SGaist

No it's not, it's an explanation on how to calculate a QDateTime from a Julian day, not how to show it as a QDateTime in a QTableView

napajejenunedk0

Yes, and then show it in the table view. Other way to convert it is using SQLite's strftime.