Hello, does anyone know how to use queryRaw with d...
# orm-helpf
friebetill
11/24/2020, 3:15 PMHello, does anyone know how to use queryRaw with dates? This doesn’t work:
Copy code
queryRaw`SELECT * FROM "User" WHERE "createdAt" > ${'1999-01-08'};`
queryRaw`SELECT * FROM "User" WHERE "createdAt" > '${'1999-01-08'}';`
queryRaw`SELECT * FROM "User" WHERE "createdAt" < ${Date()};`r
Ryan
11/24/2020, 3:17 PM@friebetill Does this work?
Copy code
queryRaw`SELECT * FROM "User" WHERE "createdAt" < ${new Date().toISOString()}`f
friebetill
11/24/2020, 3:20 PMNo unfortunately not
friebetill
11/24/2020, 3:21 PMOnly this works, but it’s not variable
Copy code
queryRaw`SELECT * FROM "User" WHERE "createdAt" < '1999-01-08'`j
Jonathan Romano
11/24/2020, 3:23 PMYou need to wrap your interpolation with quotes
💯 1
r
Ryan
11/24/2020, 3:24 PMYeah, something like:
Copy code
queryRaw`SELECT * FROM "User" WHERE "createdAt" < '${new Date().toISOString()}'`Ryan
11/24/2020, 3:34 PM@friebetill actually this works as well:
Copy code
const users = await prisma.$queryRaw`select * from "User" where "createdAt" < ${new Date()}`f
friebetill
11/24/2020, 4:16 PMThanks to both of you!
Copy code
const users = await prisma.$queryRaw`select * from "User" where "createdAt" < ${new Date()}`new Copy code
queryRaw`SELECT * FROM "User" WHERE "createdAt" < '${new Date().toISOString()}'`2 Views