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

[asuhan]

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

[EmeraldHerald]

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

Format a Date

[grafik] you don’t need to do this, do you? start_date is already that value. Can you see if removing those redundancies fixes it? Edit: By doing that you’re turning a date into a string [grafik] → [grafik]

[asuhan]

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.

[EmeraldHerald]

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

[asuhan]

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.

[asuhan]

in Version 1.29.1 the problem has been solved