Patrik Trefil Comments - Answer Overflow

Patrik Trefil

•Created by san4d on 4/11/2024 in #help

Parameterized Interval in Where Clause

Hey, I managed to get the interval typing to work. I used the MAKE_INTERVAL function. Example:

const days = 4;
lt(sql<Date>`now() + MAKE_INTERVAL(days => ${days})`, table.dateValue)

const days = 4;
lt(sql<Date>`now() + MAKE_INTERVAL(days => ${days})`, table.dateValue)

6 replies