Time format in QTableView with QSqlTableModel

[jarda]

Hello all,

I have QSqlTableModel connected to MySQL table where one column has type 'time'.
This column is used to store amount of time and I need to show it in hh:mm:ss format.
But in connected QTableView it is shown as 12:10 AM instead of 00:10:00.

Is there any way how to change the time format for this?

Thanks in advance,

Jaroslav

[andre]

I think changing your locale to a locale that uses that format by default (at least for that QTableView widget) would do it.

[jarda]

Thank You Andre for help. Locale change helped (slightly). Now it is displayed as 'h:mm'. But I need also seconds - format 'hh:mm:ss'.

Do you know how to do it?

[andre]

Other than that, I think your best bet is to subclass [[doc:QStyledItemDelegate]] and reimplement the displayText() method. You just return the time in the format you like from there.

[syrianzoro]

@QString QTime::toString ( const QString & format ) const@

Format Result
hh:mm:ss.zzz 14:13:09.042
h:m:s ap 2:13:9 pm
H:m:s a 14:13:9 pm