Node.js Drizzle PostgreSQL timestamptz 带时区的时间戳类型

timestamp()

timestamp({withTimezone: true})，传入withTimezone属性为true。

import {integer, pgTable, timestamp} from "drizzle-orm/pg-core";

const posts = pgTable("post", {
    id: integer().primaryKey(),
    createTs: timestamp({withTimezone: true}),
    updateTs: timestamp({withTimezone: true}),
})

官方文档

https://orm.drizzle.team/docs/column-types/pg#timestamp