I'm making a table in Laravel and I want my "besttime" to be a nullable
but it's returning the current time if I keep it empty.
(I'm using carbon because I want the H:i
format without the seconds)
here's what my input looks like
@foreach ($records as $record)
<tr>
<td>{{ Carbon\Carbon::parse($record->besttime)->format('H:i') }}</td>
</tr>
@endforeach
My Answer:
To make the Carbon instance nullable in Laravel, you can use the `nullable()` method when defining the column in your migration file. Here's an example of how you can make the "besttime" column nullable in your migration file:
php
Schema::create('your_table_name', function (Blueprint $table) {
$table->id();
$table->timestamp('besttime')->nullable();
// Other columns...
$table->timestamps();
});
By using the `nullable()` method, the "besttime" column will allow NULL values. This way, if the "besttime" field is empty, it will store NULL instead of the current time.
Make sure to run the migration after making this change to update your database schema.
Rate this post
4 of 5 based on 6623 votesComments