Are we able to use string instead of new Date() ?

[tombohub]

postgres generated code for table is:

export interface OvernightDailyOvernightPerformance {
  ...
  date: Timestamp;
  ...
}

I want to filter by date:

const rows = await db
    .selectFrom("overnight.daily_overnight_performance")
    .where("date", "=", "2023-06-02")
    .execute()

but it's an error:

and cannot run the script.

If I change Timestamp type from:

export type Timestamp = ColumnType<Date, Date | string, Date | string>;

to:

export type Timestamp = ColumnType<Date | string, Date | string, Date | string>;

it still shows the error:

but at least I can run the script.

Can you make it so it generates code where date string is acceptable for selection?

Upvote & Fund

• We're using Polar.sh so you can upvote and help fund this issue.
• We receive the funding once the issue is completed & confirmed by you.
• Thank you in advance for helping prioritize & fund our backlog.

[SangJunBak]

I too have this problem! Especially since Postgres accepts microsecond precision which JavasScript Date objects do not support.

[nick-cheatwood7]

This is not a perfect fix, but you can sort of trick Typescript into allowing a Date value, at least for timestamp columns in MySQL:

const isoDateString = new Date().toISOString()
// 👇 where "date_column" is a `timestamp` column
await db.insertInto("foo").values({ date_column: isoDateString as unknown as Date  }).execute()

I had a project where I needed to insert a timestamp value as a string and this worked.

[RobinBlomberg]

This sounds like a duplicate of #121. Someone posted a solution there:

import { Selectable } from 'kysely'

const results: Selectable<Thing> = await db.selectFrom('thing').selectAll().execute()

Please check if that solves the issue. If so, I will add the solution to the README.

[koskimas]

@RobinBlomberg This is a different issue. The issue is that where uses the Selectable type, which is Date in Timestamp.

@tombohub

it still shows the error:

No it doesn't. Restart vscode or reboot its typescript server. If you're able to compile that typescript, then surely the typescript running inside vscode also accepts the code.

There's probably nothing kysely-codegen should do here. If you change the selectable type, then the result type is also Date | string. What you (the user) can do is create a helper function like this:

function toDate(date: string) {
  return sql<Date>`${date}`
}

const rows = await db
    .selectFrom("overnight.daily_overnight_performance")
    .where("date", "=", toDate("2023-06-02"))
    .execute()

I'd say this is cleaner than a cast.