SQL Server: @default(now()) didn't work and put null in the database

[janpio]

via #12729 from @max-programming;

Problem

In SQL Server with Prisma, when I used @default(now()) it didn't work and put null in the database. More at #12705

Suggested solution

It would be good if the default function in the prisma schema works fine

[janpio]

I can not confirm this, both of these schemas (with and without native typewould successfully generate a date when inserting a row:

model Foo {
  id        Int       @id() @default(autoincrement())
  createdAt DateTime? @default(now()) @db.DateTime
}

model Foo {
  id   Int      @id() @default(autoincrement())
  date DateTime @default(now())
}

What am I missing @max-programming?

[max-programming]

Looks like it works then. Since then I haven't used sql server. That was a rare occassion. Also it's been a long time so this might have been patched by now ✌️

[janpio]

Ok, closing then. If this happens to anyone else, they will open another bug issue report. Thanks!