php - how to print month and year from DB date format

Question

I have date cell in my db:createDate This is the format Y-m-d. i.e: 2018-10-31

How can i print it on the screen in this format: October 2018

?

I tried this:

echo date ("Y-M", $mainIndex['createDate'])

Possible duplicate of [Convert one date format into another in PHP](https://stackoverflow.com/questions/2167916/convert-one-date-format-into-another-in-php) — ldam, Oct 31 '18 at 10:37
Possible duplicate of [Convert date to month name & year](https://stackoverflow.com/questions/45138411/convert-date-to-month-name-year) — Dave, Oct 31 '18 at 10:43

score 2 · Accepted Answer · answered Oct 31 '18 at 10:06

2

Use this

echo date ("F Y", strtotime($mainIndex['createDate']));

answered Oct 31 '18 at 10:06

Sanu0786

score -1 · Answer 2 · answered Oct 31 '18 at 10:07

-1

You were very close :) second parameter should be an integer (time)

echo date ("F Y", strtotime($mainIndex['createDate']));

answered Oct 31 '18 at 10:07

simonecosci

score -1 · Answer 3 · answered Oct 31 '18 at 10:13

-1

You can use date format php function something like this

echo date_format($mainIndex['createDate'],"F Y");

For more you can get it from it php date_format and for php date parameters Parameters

answered Oct 31 '18 at 10:13

Dipendra Deshar

score -1 · Answer 4 · edited Oct 31 '18 at 10:28

-1

you need to convert the time date unix timestamp

echo date('F Y', strtotime($mainIndex['createDate']));

edited Oct 31 '18 at 10:28

Mohammad

answered Oct 31 '18 at 10:26

Debdip

4 Answers4