#include <QtSql>

int main(int argc, char** argv)
{
    QCoreApplication app(argc, argv);
    // setting database
    QSqlDatabase db = QSqlDatabase::database();
    db = QSqlDatabase::addDatabase("QPSQL");
    db.setDatabaseName("testdb");
    db.setHostName("192.168.178.84");
    db.setUserName("testuser");
    db.setPassword("testuser");
    db.open();

    {
        QSqlQuery q;
        q.exec("DROP TABLE IF EXISTS a");
        q.exec("CREATE TABLE a ( data TIMESTAMP );");
    }

    // inserting
    auto data = QDateTime::currentDateTime();
    QSqlQuery query;
    query.prepare("INSERT INTO a VALUES (?)");
    query.addBindValue(data);
    query.exec();

    // retriving
    QSqlQuery query2;
    query2.prepare("SELECT * FROM a");
    query2.exec();
    query2.next();
    auto data2 = query2.value(0).toDateTime();

    qDebug() << data;
    qDebug() << data2;
    assert(data == data2);
}