显示日期[重复]

This question already has an answer here:

I trying to only show the date so for example 2018-04-09 and not the time. After that I want it to make it like 9 april 2018 but I can't change the database because I need the hours/seconds/minutes for an other thing. I did not found on the internet what I need in my case and what works for me. I hope someone has a tip how to make this with some kind of code.

I am new to asking questions so if I miss something to make this question work tell me.

My database

</div>

it could be your SQL query

select DATE_FORMAT(create_time,'%d %b %Y') from Table where 1 = 1;