0

When making a query to a mysql db (with node/mysql2):

.query(
      "INSERT INTO expenses (expense_date, expense_value, user_id) VALUES ?",
      ["06-08-2022", 11.33, "2"],
      true
    )

I get the following error: `sqlMessage: "Incorrect date value: '06-08-2022' for column 'expense_date' at row 1"``

I understand we need to let mysql know we are handling a Date by using probably the STR_TO_DATE method.

However, I´m not sure how to do it in mysql2

0 Answers0