Reformatting date in MYSQL for output in PHP

Question

I have a ROW in my database's table that is a TYPE = timestamp. So the saved date format is like this:

2015-11-30 14:54:04

I googled it and said this is default timestamp format of MYSQL. How can I echo this date in PHP using this format:

November 30, 2015 2:54:04 PM

Note: I am running this in a loop and the retrieved data includes this date in the whole table so the var for this date to echo is $feeds->reg_date. I hope my question is clear.

Rajdeep Paul · Accepted Answer · 2015-12-01 01:49:33Z

3

You can do something like this:

$dt = "2015-11-30 14:54:04";
$unixdatetime = strtotime($dt);
$formatted_date = strftime("%B %d, %Y %I:%M:%S %p",$unixdatetime);
echo $formatted_date;  // output: November 30, 2015 02:54:04 PM

Edited:

$unixdatetime = strtotime($feeds->reg_date);
$formatted_date = strftime("%B %d, %Y %I:%M:%S %p",$unixdatetime);
echo $formatted_date;

Re-edited

if(DateTime::createFromFormat('d/m/Y H:i:s', $feeds->reg_date)){
    $unixdatetime = DateTime::createFromFormat('d/m/Y H:i:s', $feeds->reg_date)->getTimestamp();
}else{
    $unixdatetime = strtotime($feeds->reg_date);
}
$formatted_date = strftime("%B %d, %Y %I:%M:%S %p",$unixdatetime);
echo $formatted_date;

edited Dec 1, 2015 at 1:49

answered Dec 1, 2015 at 1:02

Rajdeep Paul

16.9k3 gold badges21 silver badges39 bronze badges

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

6 Comments

Paolo Medina Over a year ago

Thanks! What if this is the date format saved 14/11/2015 20:49:22?

Paolo Medina Over a year ago

I mean, I have a different table with a row that has this format of date, 14/11/2015 20:49:22. How can I output this in this format using PHP, November 14, 2015 8:49:22 PM?

Rajdeep Paul Over a year ago

@PaoloMedina This will work if the datetime is saved in MySQL format i.e Y-m-d H:i:s. Since you're fetching the datetime from the database, it should work fine for you.

Paolo Medina Over a year ago

It has a wrong output of date. To clarify: 14/11/2015 20:49:22 = dd/mm/yyyy 08:49:22 PM.

Paolo Medina Over a year ago

I tried the above strftime("%B %d, %Y %I:%M:%S %p",$unixdatetime), --> result: January 01, 1970 12:00:00 AM. The saved date in the database is this 14/11/2015 20:49:22.

|

Ramos Alcarez Jr · Accepted Answer · 2015-12-01 01:03:31Z

1

There is a php syntax such as Date('m-d-y')); you just need to change the format of how you want the date to be displayed by using that function.

answered Dec 1, 2015 at 1:03

Ramos Alcarez Jr

195 bronze badges

Comments

Logan Wayne · Accepted Answer · 2015-12-01 01:03:22Z

0

You can use date() and strtotime()

$date = date('F d, Y h:i:s A', strtotime($row["date"]));

Check this link for more date format.

answered Dec 1, 2015 at 1:03

Logan Wayne

5,98716 gold badges33 silver badges50 bronze badges

Collectives™ on Stack Overflow

Reformatting date in MYSQL for output in PHP

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related