Convert date from yyyy-mm-dd to dd month_name year

Question

This question already has an answer here:

• Convert date format yyyy-mm-dd => dd-mm-yyyy 12 answers

I have stored date in MySQL in the format yyyy-mm-dd and I wish to display it on the form like

ddMMMMyyyy

How can I do that

Answer 1

Try it.

CONVERT(VARCHAR(11),GETDATE(),106)

Answer 2

Use DATE_FORMAT()

select date_format(date_column, '%d %M %Y')
from your_table