DT
Drizzle Team•4mo ago
bun

dates in sqlite not being evaluated, causing "Invalid Date"

    expiresAt: int("expires_at", { mode: "timestamp" })
      .notNull()
      .$defaultFn(() => new Date(Date.now() + 1000 * 60 * 60 * 24 * 365)),
    createdAt: int("created_at", { mode: "timestamp" })
      .notNull()
      .default(sql`CURRENT_TIMESTAMP`),
  
    expiresAt: int("expires_at", { mode: "timestamp" })
      .notNull()
      .$defaultFn(() => new Date(Date.now() + 1000 * 60 * 60 * 24 * 365)),
    createdAt: int("created_at", { mode: "timestamp" })
      .notNull()
      .default(sql`CURRENT_TIMESTAMP`),
I have the following columns in my sqlite table, for some reason the expiresAt column works fine, when being read, its being evaluated as an actual date, and is saved in the database as an UNIX timestamp, however, the createdAt column is being saved as an actual ISO string date, but upon quering it shows INVALID DATE, why is it?
3 Replies
bun
bun•4mo ago
Ok nice
Liam
Liam•4mo ago
Hey OP, did you ever find a solution to this?
bun
bun•4mo ago
Yeah the solution is to use sql’unixepoch’ (with template strings)
Want results from more Discord servers?
Add your server
More Posts
drizzle-kit generate migration for pg is stuck at: Reading config file 'drizzle.config.ts'Hello, im using Deno 1.41.3. After executing `deno run -A npm:drizzle-kit generate:pg` cli just showHow do I reuse the results from the where clause within the findMany?I have a vendor ID and want to retrieve all restaurant IDs and menu IDs associated with that vendor.drizzle kit generate schemas for mysql had a little type mismatched problem.Has anyone encountered a similar problem of mismatched types with the error message "MySqlVarCharBuiHow to make a text based timestamp type for sqlite with zod schema inferenceWhen I use the built in integer with mode timestamp, the generated zod schemas correctly declare thaWhat's the best way to query my db?I'm running Supabase Postgres locally with Drizzle. In production, I'd use the connection pooler wHow to query many-many with mysqlI setup a simple example to test if many-many query and ran again into the same issue. ```ts Error:How do I access config in fromDriver and toDriver when defining a custom type using customType?None of the examples do this so it's not clear how/if this is possible?Cannot get user roleI'm using Next.js with next auth and the drizzle adapter. I must be doing something wrong because th