Support 0000-00-00 00:00:00 for MySQL #5006
Description
Our mysql instance allow datetime to be zero. Seems to be failing at as some values as null or 0000-00-00, 0000-00-00 00:00:00 or 0000-00-00 00:00:00.000. Tried to read datetimes as just strings on connection string but prisma converts those back to DateTime. Also tried to return zero dates as null on the connection string.
generator photon {
provider = "photonjs"
}
generator nexus_prisma {
provider = "nexus-prisma"
}
datasource db {
provider = "mysql"
url = env("MYSQL_URL")
}
model Compliance {
id Int
expirationDate DateTime?
lastUpdateUTC DateTime
}
leads to
Could not retrieve NaiveDateTime from Value in src/libcore/option.rs:1034:5