The Set node for the Date-Time field from PostgreSQL adds a second pair of quotes

The Set node for the Date-Time field from PostgreSQL adds a second pair of quotes. Maybe it should be, but then how do you pass the value to the Set node and then on through the script?

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • **n8n version:1.25.1
  • **Database (default: SQLite):PostgreSQL
  • **n8n EXECUTIONS_PROCESS setting (default: own, main):main
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):*Docker
  • **Operating system:Ubuntu

Hi @asuhan :wave: This looks similar to what was happening in this thread, and with setting the value to a string - check out this post:

Good afternoon, EmeraldHerald. I looked, but I need to pass the date I get from PostgreSQL to Set and I don’t understand why the string from “client_name” is passed as a string, but the string from the “date_in” field gets a second pair of quotes.

Hi @asuhan :wave: That’s odd :thinking: Can you provide an example database schema so we can reproduce this? Please don’t give us any sensitive information when you do!

Good afternoon, EmeraldHerald. Are you referring to the sample data I get from PostgreSQL? If so, I attach a part of it. If not - please write what you need to do.

[{
        "date_in": "2023-11-23T21:00:00.000Z",
        "actions_discounts": "0",
        "client_name": "Лиза"
    }, {
        "date_in": "2023-11-24T21:00:00.000Z",
        "actions_discounts": "0",
        "client_name": "Дарья"
    }, {
        "date_in": "2023-12-01T21:00:00.000Z",
        "actions_discounts": "0",
        "client_name": "Дмитрий"
    }, {
        "date_in": "2023-12-01T21:00:00.000Z",
        "actions_discounts": "0",
        "client_name": "Наталья"
    }, {
        "date_in": "2023-12-01T21:00:00.000Z",
        "actions_discounts": "0",
        "client_name": "Кирилл"
    }, {
        "date_in": "2023-12-06T21:00:00.000Z",
        "actions_discounts": "3500",
        "client_name": "Пётр"
    }, {
        "date_in": "2023-12-08T21:00:00.000Z",
        "actions_discounts": "0",
        "client_name": "Сергей"
    }, {
        "date_in": "2023-12-08T21:00:00.000Z",
        "actions_discounts": "0",
        "client_name": "Артем"
    }, {
        "date_in": "2023-12-09T21:00:00.000Z",
        "actions_discounts": "10000",
        "client_name": "Иван"
    }, {
        "date_in": "2023-12-13T21:00:00.000Z",
        "actions_discounts": "0",
        "client_name": "Елена"
    }
]

Thanks.
Regards, Aleksandr.

in Version 1.29.1 the problem has been solved

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.