PHP How to change date format from variable

Question

im currently pulling data from my database along with a date via variable. The code im using is this

echo "".$row["firstname"]." ".$row["lastname"]." thinks that it will happen on ".$row["date"]."";

the results are being displayed as : bobby anderson thinks that it will happen on 2011-09-15

but id like the date to be displayed as Monday 1st August 2011

Please post the column type for date and the type of database you are using — afuzzyllama
– afuzzyllama, Commented Aug 1, 2011 at 18:12

RiaD · Accepted Answer · 2011-08-01 18:12:49Z

6

date('l jS F Y',strtotime($row['date']))

answered Aug 1, 2011 at 18:12

RiaD

47.8k12 gold badges85 silver badges128 bronze badges

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

Comments

Christian Mann · Accepted Answer · 2011-08-01 18:15:01Z

1

Take a look at the date function, along with strtotime.

answered Aug 1, 2011 at 18:15

Christian Mann

8,1455 gold badges43 silver badges52 bronze badges

Comments

cwallenpoole · Accepted Answer · 2011-08-01 18:21:54Z

1

You can either use date along with strtotime, or you can use the date_create_from_format method (date_create_from_format example):

echo DateTime::createFromFormat( "Y-n-j", $row['date'])
     ->format( 'l jS F Y' );

(an now strtotime)

echo date('l jS F Y',strtotime($row['date']));

answered Aug 1, 2011 at 18:21

cwallenpoole

82.4k26 gold badges132 silver badges174 bronze badges

3 Comments

afuzzyllama Over a year ago

+1 for using DateTime. PRO TIP DateTime is a PHP 5 >= 5.3.0 function. It is easy to use, but if you are using an earlier version you'll need to go with the second recipe!

cwallenpoole Over a year ago

Yea, all of my stuff is on PHP 5.3. I don't normally think about that limitation.

afuzzyllama Over a year ago

Some enterprise installs of linux don't use 5.3 yet. Just something to keep in mind.

Collectives™ on Stack Overflow

PHP How to change date format from variable

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related