How to convert dates to a different format from my database?

Question

In my database, dates are stored in this format:

2013-03-14

I want to show dates on my web page formatted as:

2013-march-14

I have a lot of date data already stored in my database, so it's not possible to change my database. How can I do this conversion?

Too basic a question and answered innumerous times. – asprin Mar 16 '13 at 06:10 — asprin, Mar 16 '13 at 06:10

Mahmoud Gamal · Answer 1 · 2013-03-16T06:14:29.230

0

Use the MySQL built-in DATE_FORMAT function, with the specifiers '%Y-%M-%d' to format the date parts the way you want:

SELECT DATE_FORMAT(datefield, '%Y-%M-%d')
...

edited Mar 16 '13 at 06:14

answered Mar 16 '13 at 06:08

Mahmoud Gamal

score 0 · Answer 2 · answered Mar 16 '13 at 06:24

0

If you wanted to do this on PHP you could use the date function

$d = '2013-03-04';
echo date("Y-M-d", strtotime($d));  //2013-Mar-04

answered Mar 16 '13 at 06:24

rantsh

Sumit Bijvani · Accepted Answer · 2013-03-16T06:33:58.520

0

You can do this

Via MySQL

SELECT DATE_FORMAT(datecolumn, '%Y-%M-%d') FROM table

Via PHP

$date = '2013-03-14';
echo date("Y-F-d", strtotime($date));

Output

2013-march-14

edited Mar 16 '13 at 06:33

answered Mar 16 '13 at 06:26

Sumit Bijvani

1

actually on PHP M would give you Mar not march, I can't remember what the format for full month is and for whatever reason the stupid manual not loading right now – rantsh Mar 16 '13 at 06:29
1

@rantsh for full month `echo date("Y-F-d", strtotime($date));` – Sumit Bijvani Mar 16 '13 at 06:34

3 Answers3