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