node & postgres - error: malformed array literal: timestamp

Question

I am using node and postgresql (and node-postgres).

I am trying to execute an insert statement, but I get the following error:

error: malformed array literal: "2020-01-15T20:09:22.711+02:00"

My code is as follows:

const queryInsert = {
  text: 'INSERT INTO my_table(some_date, last_update) VALUES($1, $2)',
  values: [2020-01-15T20:09:22.711+02:00, new Date()]
}

  client.query(
    queryInsert.text,
    queryInsert.values,
    (err, res)=> {
      done();
      if (err) {
        console.log('Query: '+queryInsert.text, err);
      }
      console.log(res);
    }
  );

Question

Do I need to somehow format the values if they are dates? If so, how? If not, any advise welcome.

Thank you

I have found a similar question here, but no answer stackoverflow.com/questions/51572256/… — Richard
– Richard, Commented Jan 15, 2020 at 18:24

coreyward · Accepted Answer · 2020-01-15 18:36:57Z

2

node-postgres appears to only accept dates as actual Date objects, not as strings. Documentation

const queryInsert = {
  text: 'INSERT INTO my_table(some_date, last_update) VALUES($1, $2)',
  values: [new Date("2020-01-15T20:09:22.711+02:00"), new Date()]
}

edited Jan 15, 2020 at 18:36

answered Jan 15, 2020 at 18:27

coreyward

80.5k21 gold badges148 silver badges176 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Richard Over a year ago

thank you for your reply. I tried using Date.parse(...) as you suggect, but now I get the following error: error: malformed array literal: "1555937640000".

coreyward Over a year ago

Ack, sorry, wrong method. You want to use new Date("…") there, not Date.parse(). I updated my answer.

Richard Over a year ago

If I add new Date('2019-05-04T08:00:00.000+02:00') I get the following error: malformed array literal: "2019-05-04T08:00:00.000+02:00".

Richard Over a year ago

This is strange, because even if I do the following, I get the error, which contradicts the documentation: values: [new Date(]), new Date()].

Richard Over a year ago

I changed the columns to type timestamp with time zone, and that fixed it. Thank you for your help!

|

Collectives™ on Stack Overflow

node & postgres - error: malformed array literal: timestamp

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related