Topics

Drizzle Team•6mo ago

How do I use NOW() in Drizzle?

Can someone explain how to write the following query in Drizzle?

UPDATE users
SET datetime_last_login = NOW()
WHERE id = $1

UPDATE users
SET datetime_last_login = NOW()
WHERE id = $1

3 Replies

Angelelz•6mo ago

The sql operator to the rescue:

db.update(users).set({datetimeLastLogin: sql`NOW()` }).where(eq(users.id, 1))

db.update(users).set({datetimeLastLogin: sql`NOW()` }).where(eq(users.id, 1))

Zamiel•6mo ago

Thank you very much! Is this worth adding to the docs? I feel like using NOW() must be pretty common for people using Postgres. Additionally, I did actually come across the docs talking about sql, but it wasn't clear that you can use it inside of a .set call. The only example talks about using it to replace the entire query with SQL using db.execute.

Angelelz•6mo ago

I guess you could add an issue in GH to add that to the docs

Drizzle Team Join

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

7.8KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

TypeScript type errors when running in PNPM workspaceI changed nothing about my code other than doing a full clean build. Working code now failing with t Using drizzle studio with local d1Hey, I'm trying to connct drizzle studio to my local d1 database. I'm able to connect remote just fi getPost() / getPosts() / ... what's your opinion? + any TS magician here :) ?Hello! I was thinking of creating functions which will execute my queries, instead of putting all qu What work is required to support ClickHouse?I'm a big fan of Drizzle. I'm using Clickhouse on tons of projects, it's one of the best if not the push:pg not creating table schema (pgSchema)Running a local Supabase instance, regular tables and all that work as expected. Just now trying to Drizzle JOIN vs relationsSeems like both Join and relations are equally capable when query data that have relationships. I'd update not working```ts export async function PATCH(request: NextRequest) { const body = (await request.json()) as P How do I infer type of pgEnumHow can I infer the type of a pgEnum? ```ts export const roleEnum = pgEnum('role', ['A', 'B', 'C', Is drizzle-kit supposed to include existings table in the migration file?is drizzle-kit supposed to include an existing table in the migration file (the sql file)? For conte MySQL Relational CRUDI am the own of issue #1395, it was closed but i don't know way to follow this suggestion: MySql doe