QTableView not corectly showing empty fields

[Sergey B.]

Windows XP SP2, OS X 10.4.8
PostgreSQL 8.1.3
Short description:
QTableView isn't showing correctly empty fields "timestamp without time zone " type
What I did:
I have a SLOT

acceptedmodel=new QSqlQueryModel(this);
               acceptedmodel->setQuery("SELECT orders.key, orders.time_order,
               orders.phone, orders.address, orders.address_finished,
               operators.operator_name, orders.time_driver_lock,
               orders.time_driver_wait, orders.time_driver_go,
               carting.carting_name, drivers.nickname FROM orders LEFT JOIN carting
               ON orders.typecarting=carting.key LEFT JOIN operators ON
               operators.key=orders.operator_open LEFT JOIN drivers on
               orders.driver=drivers.key  WHERE orders.isaccepted=TRUE ORDER BY
               time_order;");
               if (acceptedmodel->lastError().isValid())
               {
                       QMessageBox::information(this, tr("Qtaxi"),
                       acceptedmodel->lastError().databaseText());
                       return;
               }
               acceptedmodel->setHeaderData(0, Qt::Horizontal, tr("Num"));
               acceptedmodel->setHeaderData(1, Qt::Horizontal, tr("Order time"));
               acceptedmodel->setHeaderData(2, Qt::Horizontal, tr("Call to"));
               acceptedmodel->setHeaderData(3, Qt::Horizontal, tr("Address"));
               acceptedmodel->setHeaderData(4, Qt::Horizontal, tr("Go to"));
               acceptedmodel->setHeaderData(5, Qt::Horizontal, tr("Order
               operator"));
               acceptedmodel->setHeaderData(6, Qt::Horizontal, tr("Driver go to"));
               acceptedmodel->setHeaderData(7, Qt::Horizontal, tr("Driver wait"));
               acceptedmodel->setHeaderData(8, Qt::Horizontal, tr("Driver out"));
               acceptedmodel->setHeaderData(9, Qt::Horizontal, tr("Carting"));
               acceptedmodel->setHeaderData(10, Qt::Horizontal, tr("Nick"));
               acceptedtableView->setModel(acceptedmodel);
               acceptedselection=acceptedtableView->selectionModel();
               connect(acceptedselection, SIGNAL(currentChanged(const QModelIndex
               &, const QModelIndex &)), this, SLOT(SetAcceptedIndex(const
               QModelIndex &)));
               acceptedtableView->resizeColumnsToContents();
       }

acceptedmodel=new QSqlQueryModel(this);
               acceptedmodel->setQuery("SELECT orders.key, orders.time_order,
               orders.phone, orders.address, orders.address_finished,
               operators.operator_name, orders.time_driver_lock,
               orders.time_driver_wait, orders.time_driver_go,
               carting.carting_name, drivers.nickname FROM orders LEFT JOIN carting
               ON orders.typecarting=carting.key LEFT JOIN operators ON
               operators.key=orders.operator_open LEFT JOIN drivers on
               orders.driver=drivers.key  WHERE orders.isaccepted=TRUE ORDER BY
               time_order;");
               if (acceptedmodel->lastError().isValid())
               {
                       QMessageBox::information(this, tr("Qtaxi"),
                       acceptedmodel->lastError().databaseText());
                       return;
               }
               acceptedmodel->setHeaderData(0, Qt::Horizontal, tr("Num"));
               acceptedmodel->setHeaderData(1, Qt::Horizontal, tr("Order time"));
               acceptedmodel->setHeaderData(2, Qt::Horizontal, tr("Call to"));
               acceptedmodel->setHeaderData(3, Qt::Horizontal, tr("Address"));
               acceptedmodel->setHeaderData(4, Qt::Horizontal, tr("Go to"));
               acceptedmodel->setHeaderData(5, Qt::Horizontal, tr("Order
               operator"));
               acceptedmodel->setHeaderData(6, Qt::Horizontal, tr("Driver go to"));
               acceptedmodel->setHeaderData(7, Qt::Horizontal, tr("Driver wait"));
               acceptedmodel->setHeaderData(8, Qt::Horizontal, tr("Driver out"));
               acceptedmodel->setHeaderData(9, Qt::Horizontal, tr("Carting"));
               acceptedmodel->setHeaderData(10, Qt::Horizontal, tr("Nick"));
               acceptedtableView->setModel(acceptedmodel);
               acceptedselection=acceptedtableView->selectionModel();
               connect(acceptedselection, SIGNAL(currentChanged(const QModelIndex
               &, const QModelIndex &)), this, SLOT(SetAcceptedIndex(const
               QModelIndex &)));
               acceptedtableView->resizeColumnsToContents();
       }

To copy to clipboard, switch view to plain text mode 

What I expected to see:
when I open form I see then empty fields in database ("timestamp
without time zone " type), isn't showing correctly in QTableView.
I see "01.01.-4713 0.00.00", (Russian locale, USA locale isn't showing
correctly too)


I have some screenshots, and I can send it to you...

Does anybody can testing this?

screenshots

[jpn]

screenshots

Could you please attach the screenshots directly on the forums?

[Sergey B.]

Could you please attach the screenshots directly on the forums?

Okey.
Sorry, don't see "manage attachments"

[jpn]

Hmm, I'm not sure, maybe this is a bug in psql plugin/driver? Perhaps you could try subclassing QSqlQueryModel and fixing the date time by hand (in QAbstractItemModel::data()) as a temporary workaround?

[Sergey B.]

It's a bug (regression)
http://trolltech.com/developer/task-...8&method=entry