datetime field

[valgaba]

I have a database with a datetime field, how I can change the date to the current date time keeping?

thanks

[sonulohani]

Use QTime.
Extract time from the system and update it in the database.

[valgaba]

I have a table with a datetime field you can change all values ​​in the field of time keeping and changed the part of date.
The field looks like this:
2012-08-07T11: 38:00
You can change the 08/07/2012 holding T11: 38:00 intact.

QSqlQuery query(db);
query.prepare("UPDATE HORAS SET DIAHORA = CONCAT(?, time(DIAHORA))");
 
query.addBindValue(QDate::currentDate());
query.exec();

QSqlQuery query(db);
query.prepare("UPDATE HORAS SET DIAHORA = CONCAT(?, time(DIAHORA))");

query.addBindValue(QDate::currentDate());
query.exec();

To copy to clipboard, switch view to plain text mode 

[ChrisW67]

How you do this will depend on the database date functions and the exact type of the "date time" column. Which database engine?

[valgaba]

use QSQLITE

db = QSqlDatabase::addDatabase("QSQLITE");
 db.setDatabaseName(Path + "/Eventos/evento.evt");
 db.open();
 QSqlQuery query(db);
 
query.exec("UPDATE HORAS SET HORA = DATE_ADD(HORA, INTERVAL 1 DAY) WHERE rowid > 0");  // error

db = QSqlDatabase::addDatabase("QSQLITE");
 db.setDatabaseName(Path + "/Eventos/evento.evt");
 db.open();
 QSqlQuery query(db);

query.exec("UPDATE HORAS SET HORA = DATE_ADD(HORA, INTERVAL 1 DAY) WHERE rowid > 0");  // error

To copy to clipboard, switch view to plain text mode 

[sonulohani]

hey you're writing the wrong SQL Statements. Set all the value of Date in the variables and update it here. How SQLite will know that you're using the date_add function.