How to update time to NOW()?

Question

I want to set a date field to NOW() if it's outdated. Here is the query I'm trying to run without success:

Quiz::('date', '<', DB::raw('NOW()'))->update(['date' => DB::raw('NOW()')])

How do I fix it?

P.S
I don't want to deal with Carbon, if possible, to avoid the server/DB time difference issues.

Answer 1

Try something like:

DB::table('quizzes')->where(DB::raw('date < NOW()'))->update(['date' => DB::raw('NOW()')]);