8 replies

String default for integer timestamps?

Hey folks, I'm using Drizzle with SQLite on CloudFlare D1. Using the following column schema:

createdAt: integer("created_at", { mode: "timestamp" }).default(sql`CURRENT_TIMESTAMP`),

createdAt: integer("created_at", { mode: "timestamp" }).default(sql`CURRENT_TIMESTAMP`),

From the D1 database viewer I am seeing that Drizzle creates values that look like this

2024-01-03 03:55:45

2024-01-03 03:55:45

, whereas values inserted via direct SQL are integers properly e.g.

1703894400

1703894400

. In addition, the string values show up as

NULL

NULL

in Drizzle Studio. Could I be doing something wrong or have I encountered a bug?