<a name="p-127662-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-1" class="anchor" href="#p-127662-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-1" aria-label="Heading link"> 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 [date_…

in Version 1.29.1 the problem has been solved

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: [image] Format a Date Questions [grafik] you don’t need to do this, do you? start_date is already that value. Can you see if removin…

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. [date_from_postgresql_2]

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": "Лиза" }, { "dat…

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

Questions

EmeraldHerald February 1, 2024, 3:44pm 2

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

Topic		Replies	Views
The Set node for the Date-Time field from Microsoft SQL adds a second pair of quotes Questions data-transformation , node , microsoft-sql	2	70	November 24, 2024
Format a Date Questions expressions , postgres	11	616	January 18, 2024
Invalid Date Time with Set Node Questions transform-date , date-time	5	1369	June 13, 2023
Invalid DateTime in Set node with DateTime() function Questions expressions	5	2303	May 9, 2023
Additional double quotes being added Questions data-transformation	16	879	December 16, 2024

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

Related topics