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.