I have a number input component that I am using as part of query in this way and data['localDate']::timestamp between CURRENT_TIMESTAMP - INTERVAL '{{ numberInput1.value }} days' AND CURRENT_TIMESTAMP When I hover over the numberInput1.value it gives me the correct value (whatever is in the …

Postgres (cratedb) parameter bug

MiguelOrtiz October 19, 2024, 7:34pm 2

Hey there @dshoot,

Would this previous solution work out for you?

1 Like

Topic		Replies	Views
SQL query using INTERVAL won't take variable 💬 Queries and Resources sql	3	2412	August 2, 2023
Query with DateRange interpreted as int 💬 Queries and Resources sql , component , date-range	7	1225	July 25, 2023
PostgreSQL statement prep issue 💬 App Building	4	216	July 29, 2024
Dynamically change dates using a variable 💬 Queries and Resources	6	415	October 21, 2024
SQL query formatting across SELECT vs UPDATE requires different quoting 💬 Queries and Resources	11	476	June 13, 2024