Laravel how to change date format in the list

Question

We are retrieving the list from the database which is having date. We want to display it in different format. Suppose 10 Nov, 2014.

Here is my Code

Trail1:

$dropDown = Events::lists(DATE_FORMAT(event_date,'%d %M, %Y'), 'id');

Trail 2:

$dropDown = Events::lists("DATE_FORMAT(event_date, '%Y-%m-%d')  AS event_date", 'id')

But it throws error. Is there any way that we can use, to get desired date format in Laravel?

Normal Query:

select id, DATE_FORMAT(event_date,'%d %M, %Y') AS event_date from events

I'm just guessing, but you could try `Events::lists(DB::raw("DATE_FORMAT..."), 'id');` — lukasgeiter, Nov 10 '14 at 12:44
Can you update your question with the SQL query it generates? Use [this answer](http://stackoverflow.com/a/18236656/1903366) if you don't know how to do that... — lukasgeiter, Nov 10 '14 at 13:22
@lukasgeiter sorry to disappoint you it is not printing query. Use of undefined constant event_date - assumed 'event_date' — vvr, Nov 10 '14 at 13:27
@lukasgeiter when i gave a other query it is printing but this isn't. It is breaking at that particular point i think. — vvr, Nov 10 '14 at 13:29
Query1 (I used like this): Events::lists(DB::raw(DATE_FORMAT(event_date,'%d %M, %Y')), 'id') — vvr, Nov 10 '14 at 13:30
Query2 (I used like this): Events::lists("DATE_FORMAT(event_date,'%d %M, %Y') as event_date", 'id') — vvr, Nov 10 '14 at 13:30

score 4 · Accepted Answer · answered Nov 10 '14 at 13:47

4

This should work.

Events::lists(DB::raw('DATE_FORMAT(event_date, "%d %M, %Y")'), 'id');

In the code you posted in the question (and the comments) there's always a small mistake.

answered Nov 10 '14 at 13:47

lukasgeiter

the query is printing like this: select DATE_FORMAT(event_date, "%d %M, %Y"), `id` from `events` – vvr Nov 10 '14 at 14:06
is there any way that i can add as event_date or something like that – vvr Nov 10 '14 at 14:06
@vvr When using `lists` that wouldn't make much sense, because the return value is an array with id and value `[1 => "10 November, 2014"` – lukasgeiter Nov 10 '14 at 14:26

1 Answers1