what is the format for setting a default date in prisma manually, ex.

@default("0001-01-01T00:00:00Z")

seems to work, but it also seems to always try and change the default in the database with any new migration

ALTER COLUMN "dateAt" SET DEFAULT '0001-01-01 00:00:00 +00:00'

.

@default("0001-01-01 00:00:00 +00:00")

gives this error

Error parsing attribute "@default": Expected a datetime value, but failed while parsing ""0001-01-01 00:00:00 +00:00"": input contains invalid characters.

if i keep creating migrations it keeps trying to alter the columns default

Could you check this issue https://github.com/prisma/prisma/issues/5892 it might be related

ahha, yes, that is probably the case. didn't find it when i searched the issues