Add Time Data Format to Date Time format

I'm not sure if you can do it in the query, but you should be able to do it on the model itself. That will look like this

$offer = Offer::first();

$times = explode(':', $offer->duration);
$hours = $times[0];
$minutes = $times[1];
$seconds = $times[2];

$endTime = $offer->startTime
    ->copy()
    ->addHours($hours)
    ->addMinutes($minutes)
    ->addSeconds($seconds);

This should give you the correct result. AFAIK there is no way to do this with one method in Carbon. Anyway, you can find more examples of this in the docs: https://carbon.nesbot.com/docs/#api-addsub

I've been looking for a MySQL solution as well, and you can achieve this using ADDTIME. Something like this

ADDTIME(startTime, TIME_TO_SEC(duration)) as duration'

If you put this in a DB::raw you should be able to retrieve it in the query ;)

Documentation: https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_addtime

Are you sure you don't already have a mutator in your model like getDurationAttribute or you have added it (incorrectly) to the $dates array in your model

And when you get that error, pay attention to the file and line that errors

@snapey I have added "duration" to the date array.

    protected $dates = ['deleted_at', 'duration'];

It is a Time format data.

Is it not correct to add it to the $dates array?

So the duration is a date with a time? Like 2019-11-27 11:54:22 ?

@sinnbeck no, duration is not a date. It is a time data type formatted like: 00:30:00

That will try to format it as a date with time. Instead you could add a custom attribute handler

Something I this might work. (Be aware that it will use the current date as the date part in carbon, meaning subtracting it might be wrong. Look into the previous answers to know how to handle that properly)

public function getDurationAttribute( $value ) {
  return Carbon::parse($value);
}

Adding the duration to the dates array will cause this error Unexpected data found. Unexpected data found. Data missing because eloquent is trying to parse it into a full datetime carbon object, which it can never be.

Do you have any control over duration? Is there anyway it can be converted to just total minutes?

If not then I think you need to explode the string into its parts.

$hms = explode(':',$offer->duration)

$endTime = $startTime->copy()->addHours($hms[0])->addMinutes($hms[1])->addSeconds($hms[2]);

@snapey NO, I did not have control over it. But I did implemented a very similar solution that @bobbybouwmann was explaining in the first answer. Thanks you both

Then please mark Bobby's answer as best reply.