i'm having a trouble on comparing two dates in laravel. In my app i have a date field to compare: // example $order_date = Carbon::now()->format('Y-m-d') // returns "2022-11-30" $now = Carbon::now() // returns an object with date at the bottom…
I want to get closest date from $search_date if is not same values in $array['date']. If is same value in $array['date'] I want all array. Format date is 'Y-m-d'. Example 1: $search_date = '2022-12-08'; $array = [{"price":"200","date":"2022-12-12"},{"price":"50","date":"2022-12-10"},{"price":"100","date":"2022-12-10"}] Return should be:…
Hello I have laravel project that store data created_at as a timestamp, I would call it from database, but it still show timestamp format, how can I convert it to date format without changing my column type? image here is…
I`ve got code that shows all of the placements for a user. Is there a way to narrow this down to only show placements that are in the future? I've tried to do this using where and carbon::now to no…
i have two date : $from = 2022-11-01 $to = 2022-11-05 now , i wanna create a array like this : $date = ['2022-11-01','2022-11-02','2022-11-03','2022-11-04','2022-11-05'] and now check '2022-11-03' is exist in $date array or not. alrady use : $date =…
I'am very confused to get someone's birthday date by changing Y-m-d to m-d in the date_birth field. How should I do? This is my current code: $getBirthday = Karyawan::where('date_birth', Carbon::now()->format('m-d'))->get(); Thanks, I want to get someone's birthday by taking m-d…
I have an array contain n number of elements can be 6 or 8, like that: $langs = ["PHP", "JAVA", "Ruby", "C", "C++", "Perl"]; I would like to add one year evenly next to the elements Desired output in case…
I want to check difference between two times in Laravel (the day is not needed) Carbon::createFromTimeString($this->debut) ->diffInHours(Carbon::createFromTimeString($this->fin)) if $this->debut = '08:00:00' and $this->fin = '02:00:00' the expected result is 18 but I have 6 How can I get the correct…
I recently update my laravel 8 and It seems like Carbon or date request is not working properly I am getting the following error while saving the record with date time exception: "Error" file: "/../vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php" line: 848 message: "Call to…
I have an issue with the time returned from my database, everything is 2 hours in the past. I've been troubleshooting this issue for a bit, and checked the following: /etc/php.ini is only ini in use and has date.timezone =…