Skip to content

Instantly share code, notes, and snippets.

@jdrago999

jdrago999/drizzle-orm-datetime-query.ts

Forked from mkanenobu/drizzle-orm-datetime-query.ts
Created August 23, 2023 03:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jdrago999/284d327693518263331bb6b3534adecc to your computer and use it in GitHub Desktop.
Save jdrago999/284d327693518263331bb6b3534adecc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
drizzle-orm-datetime-query.ts
export const datetimeWithTZ = <T extends ColumnBaseConfig>(
column: MySqlDateTimeString<T>
) =>
sql`DATE_FORMAT(${column}, '%Y-%m-%dT%TZ')`.mapWith((v) => new Date(v));
// example
// await db.select({ createdAt: datetimeWithTz(table.createdAt) }).from(table);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment