javascript - NodeJs insert current Datetime field into MySQL db

Question

I'm trying to insert a DATETIME field into my MySQL db.

var dt = require('moment')().format('YYYY-MM-DD HH:mm:ss');
    pool.query(
      `insert into login(id, id_utente, data_login) values(NULL,?,?)`,
      [results[0].id],
      [dt],
      (error, results, fields) => {
      }
    );

I get this error:

C:UsersigerDesktopprovaREST_API_WITH_MYSQL-master
ode_modulesmysqllibprotocolParser.js:437
  throw err; // Rethrow non-MySQL errors
  ^TypeError: this._callback.apply is not a function

If I try this code, everything comes right:

pool.query(
      `insert into login(id, id_utente, data_login) values(NULL,?,"2021-01-27 00:00:00")`,
      [results[0].id],
      //[dt],
      (error, results, fields) => {
      }
    );

What i'm doing wrong?

question from:https://stackoverflow.com/questions/65922107/nodejs-insert-current-datetime-field-into-mysql-db

Answer 1

You have your parameters in 2 separate arrays. Put your parameters in the same parameter array.

 pool.query(
  `insert into login(id, id_utente, data_login) values(NULL,?,?)`,
  [results[0].id, dt],
  (error, results, fields) => {
  }
);