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

问题:

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

回答1:

Use DATE_FORMAT()

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

回答2:

Try it.

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