Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

380
Views
¿Cuál es la sintaxis correcta para actualizar la columna TimeStamp en PostgreSQL con Node JS?

Quiero actualizar mi columna de marca de tiempo en PostgreSQL con esto:

 function updateStatusCreated(request, response, next) { const date_generation_file = new Date(); pool.query( `UPDATE data SET report_status = 'CREATED', date_generation = '${date_generation_file}'` ), (error, results) => { if (error) { return next(error); } return response.status(200).json(results); }; return next(); }

Pero recibo este mensaje de error:

 UnhandledPromiseRejectionWarning: error: syntax error at or near "'Tue Oct 19 2021 14:19:29 GMT+0200 (GMT+02:00)'"

Los parámetros de la columna son "marca de tiempo con zona horaria"

about 4 years ago · Juan Pablo Isaza
1 answers
Answer question

0

La elección perfecta es usar Sequelize ORM

about 4 years ago · Juan Pablo Isaza Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!