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?
