PHP convert time format

Question

In my database I have a date like 2013/11/12 and it must be converted in 12th November 2013. Here there is my code:

$a=mysqli_connect("localhost","usern","pass","my_mk7vrlist");

//as you can see I'm getting the value of the date from a MySQL database

$res= mysqli_query($a,"SELECT * FROM 0_vrs_europe ORDER BY `vrs` DESC, `date` ASC LIMIT 0 , 150");

while($row = mysqli_fetch_array($res))
  {
  echo "<tr>";
  echo "<td>" . $row['status'] . "</td>";
  echo "<td>" . $row['date'] . "</td>";
  echo "</tr>";
  }

mysqli_close($res);
?>

The $row['date'] contains the date in 2013/11/12 format and it must be converted in 12th November 2013 as I have already said. How could I do it?

I have googled the function date but I can't understand how to use it here.

fr2.php.net/manual/en/function.date.php PHPs date function

Cups
– Cups

2014-02-28 17:11:55 +00:00
Commented Feb 28, 2014 at 17:11 — Cups
– Cups, Commented Feb 28, 2014 at 17:11

The Blue Dog · Accepted Answer · 2014-02-28 17:15:04Z

1

$date = date("jS F Y", strtotime($row['date']));

answered Feb 28, 2014 at 17:15

The Blue Dog

2,4753 gold badges21 silver badges25 bronze badges

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

Comments

aksu · Accepted Answer · 2014-02-28 17:19:01Z

0

Use date()s second parameter:

$formatted = date('jS F Y', strtotime($row['date']));

edited Feb 28, 2014 at 17:19

answered Feb 28, 2014 at 17:13

aksu

5,2365 gold badges26 silver badges39 bronze badges

3 Comments

The Blue Dog Over a year ago

This would output 3th

cmorrissey Over a year ago

you need to use S for the suffix

The Blue Dog Over a year ago

@cmorrissey: Yes, as I posted.

Collectives™ on Stack Overflow

PHP convert time format

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related