7 replies

Issues with timestamp precision with postgres

Hi, I posted the other day about a bug with the

date

date

timestamp

timestamp

which has a similar issue, when using mode

string

string

drizzle is returning a

Date

Date

instance (conflicting with the generated types)

To make matters worse, when using

mode: 'date'

mode: 'date'

we lose all millisecond precision

This is the column I am defining

createdAt: timestamp('created_at', { mode: 'string', precision: 3 }).defaultNow().notNull();

createdAt: timestamp('created_at', { mode: 'string', precision: 3 }).defaultNow().notNull();

This maintains the precision, but then the types are incorrect.

Has anyone faced this issue? Is this is a bug in drizzle?