2 replies

Issue with filtering on timestamp column

I have a postgres database, using

pg-core

pg-core

.

A table has a row defined as:

expirationDate: timestamp("expiration_date", { mode: "date" }).notNull()

expirationDate: timestamp("expiration_date", { mode: "date" }).notNull()

I am attempting to write a query to delete records that have an

expirationDate

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

lt

function, specifically: "No overload matches this call."

Drizzle Team•2y ago•

2 replies

Issue with filtering on timestamp column

I have a postgres database, using

pg-core

pg-core

.

A table has a row defined as:

expirationDate: timestamp("expiration_date", { mode: "date" }).notNull()

expirationDate: timestamp("expiration_date", { mode: "date" }).notNull()

I am attempting to write a query to delete records that have an

expirationDate

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

lt

function, specifically: "No overload matches this call."

Issue with filtering on timestamp column

Similar Threads

Issue with filtering on timestamp column

Similar Threads

Similar Threads

Similar Threads