CodeIgniter Forums

Full Version: Model is not producing MySQL error #1292
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Code:
$this->set('verification_code', NULL)
    ->set('email_verified_at', "Any-string")
    ->where([
        'email'=> $email,
        'email_verified_at' => NULL,
        'verification_code' => $verification_code,
    ])->update();
CI4, CI_ENVIRONMENT = development
The Model is inserting "0000-00-00 00:00:00" in column `email_verified_at`. Why CI4 not producing a MySQL error #1292 - Incorrect datetime value?
Because that is the MySQL default datetime value.