How to covert date and time using Carbon date format?

Got it!

Carbon::parse($request->start_date_time)->format('Y-m-d H:i:s');

Any further suggestions???

use Carbon parse to take the string, then you can format it however you want.

Carbon\Carbon::parse('2020-09-04T16:58')->format('Y-m-d H:i:s');

other suggestions? Leave it as a Carbon object for as long as possible.

Formatting cribsheet https://talltips.novate.co.uk/laravel/php-datetime-formatting-cribsheet

@snapey But for some reason its not able to store the record getting following error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'start_date_time' in 'field list' (SQL: insert into `campaigns` (`user_id`, `title`, `description`, `start_date_time`, `finish_date_time`, `venue`, `organizer`, `email`, `phone`, `image`, `updated_at`, `created_at`) values (2, Sea Surfing, <p>Test</p>, 2020-09-05 16:05:00, 2020-11-07 16:05:00, Chicago, IL, SunnyBoy, [email protected], 5879669661, 1597702955.jpeg, 2020-08-17 22:22:35, 2020-08-17 22:22:35))

EventsController

    public function store(EventRequest $request)
    {
        $event                   = new Campaign;
        $event->user_id          = auth()->id();
        $event->title            = $request->title;
        $event->description      = $request->description;
        $event->start_date_time  = Carbon::parse($request->start_date_time)->format('Y-m-d H:i:s');
        $event->finish_date_time = Carbon::parse($request->finish_date_time)->format('Y-m-d H:i:s');
        $event->venue            = $request->venue;
        $event->organizer        = $request->organizer;
        $event->email            = $request->email;
        $event->phone            = $request->phone;

        if ($request->hasFile('image_file')) {
            $newImage = time() . '.' . $request->image_file->extension();
            $request->image_file->storeAs('images/events', $newImage);
            $event->image = $newImage;
        }
        $event->save();

        toast('Event created successfully!', 'success');

        return redirect()->route('events.index');
    }

Migration

Schema::create('events', function (Blueprint $table) {
    $table->id();
    $table->unsignedBigInteger('user_id');
    $table->string('image');
    $table->string('title');
    $table->text('description');
    $table->dateTime('start_date_time');
    $table->dateTime('finish_date_time');
    $table->string('venue');
    $table->string('organizer');
    $table->string('email');
    $table->string('phone');
    $table->timestamps();
});

Any idea??? Thanks!

@snapey my bad found the issue! It was the model name! Grrrr!