Good morning,
I am designing a REST API with NODEJS and when I insert this query:
function getInvTop(req, res) {
if (connection)
{
connection.query('SELECT recvTimeTs, CONVERT_TZ(recvTime, '+00:00', '+02:00'), fiwareServicePath, entityId, entityType, attrName, attrType, attrValue, attrMd FROM iof.invjuan WHERE attrName = "sensor2" ORDER BY recvTime DESC LIMIT 15', function(err, rows) {
if(err)
{
throw err;
console.log('Error al Conectar' + error);
}
else
{
res.status(200).json(rows);
}
});
}
}
I get the following error:
connection.query('SELECT recvTimeTs, CONVERT_TZ(recvTime, '+00:00', '+02:00'), fiwareServicePath, entityId, entityType, attrNa
me, attrType, attrValue, attrMd FROM iof.invjuan WHERE attrName = "sensor2" ORDER BY recvTime DESC LIMIT 15', function(err, rows) {
^^
SyntaxError: missing ) after argument list
How can I solve this problem?
fails for this, CONVERT_TZ(recvTime, '+00:00', '+02:00')
, if I delete it works but I need it to put the European date.
This query in MySQL Workbench does work.
a greeting and thanks.