[BUG]: drizzle-zod type doesn't return z.ZodDate for dataType date

[ryuudotgg]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.38.0

What version of drizzle-kit are you using?

0.30.0

Other packages

[email protected]

Describe the Bug

export const table = mysqlTable(
  "table",
  {
    createdAt: timestamp("created_at", { mode: "date", fsp: 3 })
      .notNull()
      .defaultNow(),
  },
);

export const schema = createInsertSchema(table);

In the example above, the returned type for createdAt is z.ZodString instead of z.ZodDate, regardless of the dataType.

I should mention that everything is correct during runtime, the issue is only in the types.

It used to work in [email protected]

[MickL]

I think this is correct, isnt it? I dont know exactly about MySQL but I know for example that in PostgreSQL a number will always be a string because this is the most accurate way to save decimals. I imagine a timestamp will also return a string and not an actual date object.

[ryuudotgg]

You're partially correct, it is stored as a string in the database, however the mode here is date, not string, which means Drizzle ORM will parse it as a JS Date.

You can also see this being done in the exact same way during runtime: column.ts#L92

@MickL

[L-Mario564]

@nemanjastanic Can you provide the full definition for the table alongside exactly how you've defined the schema? Unable to reproduce with the sample code you provided.

[ryuudotgg]

Hey @L-Mario564, I just retried this, it seems it's caused by #3732. I missed this previously because I managed to suppress the error by adding .partial({}).

Please feel free to close this issue if you want to consider it a duplicate!

[L-Mario564]

@nemanjastanic Will close this in favor of the one you mentioned. Thanks.