When I use

@createdAt

,

@updatedAt

, prisma creates two columns with

timestamp without timezone

type in Postgresql. I try to change their type to

timestamp with timezone

, but when I redeploy, the error show up

Encountered unknown SQL type timestamptz with column createdAt

If I change their type back to

timestamp without timezone

, I can deploy successfully. So my question is

How can I use timestamp with timezone in Postgresql?

What about using timestamp without timezone and converting data when retrieving?

@bkstorm See: https://github.com/prisma/prisma/issues/4190