将DATE_FORMAT转换为Y-m-d吗?使用Larave雄辩的原始选择 [英] Convert DATE_FORMAT to Y-m-d? Using Larave Eloquent Raw Select

问题描述

目前，我在laravel中有这个雄辩的选择

Currently I have this eloquent select in laravel

$ queryBooking = Booking :: where('id'，$ id)-> select('starts_at'，'ends_at')-> first();

现在，我想使用此格式 Y-m-d

Now I want to put specific format to starts_at and ends_at using this format Y-m-d

应该向数据显示类似 2020-05-29 (Y-m-d)

Data should be shown somethings like this 2020-05-29 (Y-m-d)

我该如何使用laravel雄辩地做到这一点?

How can I do that using laravel eloquent?

更新

尝试了多刺的答案，做了一些修改.

tried the answer of spiny did some modification.

 $queryBooking = Booking::where('id',$id)->select('starts_at','ends_at')->first();

 $booking = PropertyBooking::where('property_id',$queryBooking->property_id)
    ->selectRaw(
        'DATE_FORMAT(`starts_at`, "%Y-%m-%d") AS `starts_at`, DATE_FORMAT(`ends_at`, "%Y-%m-%d") AS `ends_at`'
    )->get();

    return view('admin.pages.property_request.edit', compact('property_request','booking'));

在我的刀片中尝试使用js这样记录日志

in my blade tried to log it using js says like this

推荐答案

这是怎么回事:

->selectRaw(
    'DATE_FORMAT(`starts_at`, "%Y-%m-%d") AS `starts_at`, DATE_FORMAT(`ends_at`, "%Y-%m-%d") AS `ends_at`'
)

您也可以将其用作作用域:

Also you can use it as a scope:

public function scopeSelectStartEndDates($query) {
    return $query->selectRaw(
        'DATE_FORMAT(`starts_at`, "%Y-%m-%d") AS `starts_at`, DATE_FORMAT(`ends_at`, "%Y-%m-%d") AS `ends_at`'
    );
}

$model = Model::selectStartEndDates()->first();

这篇关于将DATE_FORMAT转换为Y-m-d吗?使用Larave雄辩的原始选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！