Skip to content

Support dates with sqlite drizzle #201

@kilisei

Description

@kilisei

Describe the feature

Atm when we define a schema e.g:

const users = dSqlite.sqliteTable("users_schema", {
  id: dSqlite.numeric("id"),
  name: dSqlite.text("name"),
  email: dSqlite.text("email"),
  joinDate: dSqlite.integer({ mode: "timestamp" }),
});

when we select from it:

const res = await drizzleDb.select().from(users).all();

The date is returned as an integer timestamp, but we want a Date object, as used by the default DrizzleORM implementation.

Additional information

  • Would you be willing to help implement this feature?

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions