[BUG]: Wrong data type for postgres date colum

[PhilippDehler]

What version of drizzle-orm are you using?

0.27.2

What version of drizzle-kit are you using?

0.19.9

Describe the Bug

Hey,

First of all, we'd like to express our enthusiasm for using Drizzle - it's an awesome tool. However, we have encountered a bug that requires attention.

We created a pgTable with a date column in TypeScript, as shown below:

const SomeDateModel = pgTable("some_data_model", {
  id: serial("id").primaryKey(),
  date: date("date").notNull(),
});

 type SomeDateModel = InferModel<typeof SomeDateModal>; //type SomeDateModel = { id:number; date:string }

The issue we've encountered is that TypeScript is reporting an unexpected data type. It expects a string but receives a date in the result. For instance:

const someDateResult = await client.query.someDateModel.findFirst() // { id:1, date: 2023-10-24T00:00:00.000Z }

Expected behavior

I would expect either a string like '2023-01-01' or the proper Date-type in the infered model

Environment & setup

We are using:
"node": "18.14.0",
"pnpm": "8.6.0",
"drizzle-orm": "0.27.2".
"drizzle-kit": "0.19.9"

[arxpoetica]

I'm hitting this bug. I ended up doing:

date: sql`to_char(${transactions.date}, 'YYYY-MM-DD')`,

[SkaceKamen]

I've had the same issue, specifying mode: "date" at least provides proper type:

birthDate: date('birth_date', { mode: 'date' }),

This doesn't change the behaviour, but fixes the incorrect type. Using mode: "string" doesn't fix the issue.

[Hebilicious]

@Angelelz this should be fixed as well right ?

[Angelelz]

Give it a try in the beta tag and let me know

[ArjobanSingh]

Hi @Angelelz,
I installed 0.29.4-d783960 beta version and bug is fixed in that, but not yet fixed in main 0.29.4 version though. Is it something which will be released in next version?

[AndriiSherman]

Should be fixed in drizzle-orm@beta. I would appreciate some feedback to confirm whether this issue has been resolved in this tag.

I plan to release it in version 0.30.0 tomorrow or within the next few days; I simply aim to address this substantial set of issues we're encountering. I'll be duplicating this message across all similar issues we're facing.

[PhilippDehler]

I tried it and it is fixed.

[AndriiSherman]

Fixed in drizzle-orm@0.30.0

Please check release notes for more info