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
Asked
Active
Viewed 1,519 times
-2
-
Did you try any code ? – Mahmood Rehman Jan 16 '14 at 11:47
-
@MahmoodRehman: I tried But gave error saying call to undefined function convert() I got this code in one of the forums here – user3202338 Jan 16 '14 at 11:49
-
pleas look at the `Date()` and `DateTime()` on `php.net`. – Mahmood Rehman Jan 16 '14 at 11:50
-
Convert isnt even a php function ... – Realitätsverlust Jan 16 '14 at 11:52
2 Answers
1
Use DATE_FORMAT()
select date_format(date_column, '%d %M %Y')
from your_table
juergen d
- 201,996
- 37
- 293
- 362
