Laravel Migration Add DateTime Column Example
Hi Developer,
This tutorial will give you an example of laravel migration add datetime column. In this article, we will implement a how to add datetime datatype in laravel migration. This post will give you a simple example of laravel migration datetime field. I explained simply about laravel migration datetime column. So, let's follow a few steps to create an example of laravel migration create datetime column.
Laravel migration provides dateTime() to add date data type in mysql table. in this example, we will create pages table with publish_date field with date datatype. so, let's see the simple migration code:
Example:
Here, we will create pages table with add date to data type.
Create new migration using following command:
php artisan make:migration create_pages_table
Now, You can update it as like the bellow:
database/migrations/migration_name.php
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
return new class extends Migration
{
/**
* Run the migrations.
*/
public function up(): void
{
Schema::create('pages', function (Blueprint $table) {
$table->id();
$table->string('title');
$table->text('body');
$table->dateTime('publish_date')->nullable();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::dropIfExists('pages');
}
};
Now, you are ready to run migration command:
php artisan migrate
You will see the layout as like the below:
I hope it can help you...
Hardik Savani
I'm a full-stack developer, entrepreneur and owner of ItSolutionstuff.com. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Laravel, Angular, Vue, Node, Javascript, JQuery, Codeigniter and Bootstrap from the early stage. I believe in Hardworking and Consistency.
We are Recommending you
- How to Add Mediumblob Data Type using Laravel Migration?
- Laravel Migration Remove Auto Increment Example
- How to Change Column Position in Laravel Migration?
- How to Migrate SQL File in Laravel Migration?
- Laravel Migration Change Datatype Date to Timestamp Example
- Laravel Migration Change Datatype String to Integer Example
- How to Drop Soft Delete from Table using Laravel Migration?
- Laravel Migration Add Column After Column Example
- Laravel Migration Default Value Current Timestamp Example
- How to Update Enum Value in Laravel Migration?
- Laravel Migration Add Enum Column Example
- Laravel Migration Custom Index Name Example
- Laravel Migration Custom Foreign Key Name Example
- How to Remove Column from Table in Laravel Migration?