Search code examples
laraveldatephp-carbon

How to select format date using carbon?

How to select format date using carbon ?

I'm used format ->select(DB::raw("(DATE_FORMAT(score_dt, '%M'))")) before.

I want to change the format by using carbon, how do I use it in a select query? to display month name

Solution

  • Have a read of the Carbon docs. Laravel uses Carbon 2 now.

    You should be able to get the month name with the monthName property: $yourDateObject->monthName.

    Carbon, however, is a PHP library and is not part of the database you're using. This means you can't use it in your select query, to use Carbon, you'll need to format your data in your model/controller/frontend. This is a fairly standard way of turning ISO8601 dates into human readable form.