Default values to integer timestamps in sqlite
I would like to set a default timestamp on record create in mysql.
My schema look like this:
export const users = sqliteTable("user", {
...
createdAt: integer("createdAt", { mode: "timestamp_ms" }) .default(new Date())
}
Unfortunately this doesn`t work. Db push throws an error: "SqliteError: near "Aug": syntax error"
Typescript is not accepting time as number.
Can anybody help me to fill the proper value in default method?
My schema look like this:
export const users = sqliteTable("user", {
...
createdAt: integer("createdAt", { mode: "timestamp_ms" }) .default(new Date())
}
Unfortunately this doesn`t work. Db push throws an error: "SqliteError: near "Aug": syntax error"
Typescript is not accepting time as number.
Can anybody help me to fill the proper value in default method?
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Similar Threads
Was this page helpful?
