DT
Drizzle Team•2mo ago
TH

Issue with filtering on timestamp column

I have a postgres database, using pg-core. A table has a row defined as: expirationDate: timestamp("expiration_date", { mode: "date" }).notNull() I am attempting to write a query to delete records that have an expirationDate in the past with this: 
const deletedUserIds: { deletedId: string }[] = await db
  .delete(TokensTable)
  .where(lt(TokensTable.expirationDate, Date.now()))
  .returning({ deletedId: TokensTable.user });
const deletedUserIds: { deletedId: string }[] = await db
  .delete(TokensTable)
  .where(lt(TokensTable.expirationDate, Date.now()))
  .returning({ deletedId: TokensTable.user });
I am getting an error on the lt function, specifically: "No overload matches this call."
2 Replies
TH
TH•2mo ago
(I'm running typescript)
rphlmr ⚡
rphlmr ⚡•2mo ago
Hello, Date.now() returns a number and expirationDate is a Date. You could try new Date()
Want results from more Discord servers?
Add your server
More Posts
orderBy in nested findManyThe docs suggest that I can order a nested findMany (https://orm.drizzle.team/docs/rqb#order-by) LikfindManyIf no rows are found, does it return undefined or an empty array?Select in nested findMany query ?Hi, I need some help with part of my code I have `many-to-many` relation between two tables `items` LibsqlError: URL_INVALID: The URL is not in a valid formatOut of nowhere I started getting this error, whats even weiirder is that it only occurs on one routeComposite PKsry if im being stupid but i wanna make this composite primary key. I create this schema push it to Drizzle doesn't know how to serialize a bigintWhen using a defaultValue for a bigint like this: ``` storage: bigint('storage', {mode: 'bigint'}).d