PostgreSQL update timestamp column from datapicker fails

Question and Answers
1

There’s a column of type timestamp in my PostgreSQL database which I want to update with a qery like this:

UPDATE orders
SET due={{dueDatePicker.selectedDate}}
WHERE id={{Orders.selectedRow.id}};

This fails - with some meaningless TypeError: d is undefined in the console.

In the network tab, I see that the call to the execute endpoint has a param dueDatePicker.selectedDate with a value ‘2022-01-28T00:00:00.000Z’ which looks ok. The respective update statement in an SQL console on the DB like this works ok as well:

UPDATE orders
SET due='2022-01-28T00:00:00.000Z'
WHERE id=2

So why does the query fail?

Along those lines: Is there some way to find out what the actual query which is sent to the DB really looks like?

2

Never mind, found the problem, it was in my brain :wink: