best practices for 'Incorrect datetime value' scenarios when inserting records into MySQL with Laravel?
I'm working with an scenario when trying to insert records into my MySQL database from a Laravel application... Specifically, I'm getting the behavior `SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value` when I try to insert a datetime value into the `created_at` column of a table. The value I'm trying to insert is `2023-02-30 12:00:00`, which is invalid since February has only 28 or 29 days depending on the year. Initially, I thought I could handle invalid dates in my application before the insert operation, but I still receive this behavior. I’m using MySQL version 8.0.26 and Laravel version 8.83. I have already attempted to validate the date format using Laravel's built-in validation rules: ```php $request->validate([ 'date_field' => 'required|date_format:Y-m-d H:i:s', ]); ``` However, the validation seems to happen after the record is attempted to be inserted, which doesn't prevent the SQL behavior from occurring. I’ve also tried to catch the exception in my controller, but it seems like the behavior originates before it can be caught: ```php try { Model::create($request->all()); } catch (Exception $e) { return response()->json(['behavior' => $e->getMessage()], 500); } ``` I don't want to modify the database schema to accept invalid dates, so I'm looking for a way to ensure that the datetime value is valid before attempting the insert. Is there a way to enforce this validation at the model level using Laravel? Or should I implement a custom validation rule? Any insights on how to handle this gracefully would be appreciated. Any ideas what could be causing this?