Convert mysql date format YYYY-MM-DD to DD, MM, YYYY

by Ramya 2012-11-03 19:40:32

Convert mysql date format YYYY-MM-DD to DD, MM, YYYY:

You can Convert mysql date format YYYY-MM-DD to DD, MM, YYYY using the DATE_FORMAT() in mysql,

SELECT DATE_FORMAT(table.fieldname,'%e %m, %y') FROM tablename

1138
like
0
dislike
0
mail
flag

You must LOGIN to add comments