Change date format to a database value

Question

I am displaying a 'date' Database value on a web page. I use Dreamweaver to build web pages which as I'm sure most are aware produces the PHP when binding the database value to the page. SO I have...

<span class="date"><?php echo $row_rsLatest['date']; ?></span>

The 'date' column on the SQL database holds the value in the YYYY-MM-DD format. I would like to change the format to '28 September 2016' using the 'dFY' syntax. I have tried applying 'date_format' to the above without success.

Can anyone help?

Thanks in advance.

echo date('"d F Y"', strtotime($row_rsLatest['date']));

JYoThI
– JYoThI

2016-09-28 09:57:34 +00:00
Commented Sep 28, 2016 at 9:57 — JYoThI
– JYoThI, Commented Sep 28, 2016 at 9:57
try my answers @steve joiner

JYoThI
– JYoThI

2016-09-28 10:13:01 +00:00
Commented Sep 28, 2016 at 10:13 — JYoThI
– JYoThI, Commented Sep 28, 2016 at 10:13

Keyur Chavda-kc1994 · Accepted Answer · 2016-09-28 10:01:18Z

1

Try this will may help you,

<span class="date"><?php echo date('d M Y',strtotime($row_rsLatest['date'])); ?></span>

answered Sep 28, 2016 at 10:01

Keyur Chavda-kc1994

1,0551 gold badge13 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Keyur Chavda-kc1994 Over a year ago

Glad to help you.

502_Geek · Accepted Answer · 2016-09-28 10:02:49Z

1

You can use like that.

echo date('d F Y',strtotime($yourDate));

answered Sep 28, 2016 at 10:02

502_Geek

2,1462 gold badges24 silver badges35 bronze badges

Comments

Vural · Accepted Answer · 2016-09-28 10:16:00Z

0

You can use strtotime() and date():

$date = date("d-F-Y", strtotime($row_rsLatest['date']));

edited Sep 28, 2016 at 10:16

answered Sep 28, 2016 at 10:00

Vural

8,75611 gold badges43 silver badges58 bronze badges

1 Comment

JYoThI Over a year ago

if you don't mind M - A short textual representation of a month (three letters)

JYoThI · Accepted Answer · 2016-09-28 10:34:02Z

0

Try this Date() format

<?php echo date('d F Y', strtotime(date('2016-09-28'))); ?>

OUTPUT:

28 September 2016

edited Sep 28, 2016 at 10:34

answered Sep 28, 2016 at 10:03

JYoThI

12.1k1 gold badge13 silver badges26 bronze badges

Collectives™ on Stack Overflow

Change date format to a database value

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Related