Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
I want to fetch data by month, so I have the following query:
->select(DB::raw('MONTH(created_at) as date'))
But then it returns the date as the number of the month.
So I tried to add FORMAT to the query, but it's not working:
->select(DB::raw('FORMAT (MONTH(created_at), "MM-yy") as date'))
how can I use the FORMAT correctly?
What you are looking for is DATE_FORMAT
->select(DB::raw('DATE_FORMAT(created_at, "%M-%y") as date'))
However you might be better to not try to format the date in the database query and use carbon to format the date in php / blade (more here https://laracasts.com/discuss/channels/general-discussion/how-to-carbonparse-in-ddmmyyyy-format) or even in javascript using days.js (https://day.js.org)
@richardhulbert The problem I need to both use MONTH because later I want to group by the month so I need to do FORMAT on MONTH
*Edit: Thank you, my bad. Now it works. Btw, I need to format it on the query itself since I send this data as is back to the frontend as it expects this format so it's quicker to execute
What's wrong with @richardhulbert 's answer? What else are you looking for?
@sr57 You're right, my bad I was supposed to completely replace MONTH. It works,
Please or to participate in this conversation.