c# - Convert MySQL Date to long format date -

c# - Convert MySQL Date to long format date -

i retrieving info mysql database , 1 of columns date type column.

mysql stores dates in yyyy-mm-dd format.

i want date such 2014-10-20 printed out 20th october, 2014

you can utilize '%d %m, %y' format convert date desired format

select date_format('2014-10-20','%d %m, %y') table

date_format

demo

c# mysql