PHP / SQL display dates in format

Question

In an SQL database I'm storing various dates, such as date of birth and date they joined my system, in the standard SQL format YYYY-mm-dd, however I wish to display these to my British users (all my users) in the format dd-mm-YYYY.

I've tried pretty much everything I found online about doing this, however cannot decipher how it's done correctly. The code I list below is what I am currently using, however it does not display the correct date stored in the database and instead uses a completely random date of 01-01-1970. Some assistance on resolving this issue would be greatly appreciated.

while($row = $results->fetch_assoc()){
                array_push($_SESSION["ActQueue"], array($row["username"], $row["surname"], $row["forename"], date('d-m-Y', $row["dob"]), $row["gender"], $row["joined"]));
}

$data = 0;
echo json_encode(['Username'=>$_SESSION["ActQueue"][0][0], 'Surname'=>$_SESSION["ActQueue"][0][1],'Forename'=>$_SESSION["ActQueue"][0][2],'DoB'=>$_SESSION["ActQueue"][0][3], 'Gender'=>$_SESSION["ActQueue"][0][4], 'Joined'=>$_SESSION["ActQueue"][0][5]]);

Fabio · Accepted Answer · 2016-12-08 18:07:06Z

1

You need to convert your plain text date to time before passing to date() function

date('d-m-Y', strtotime($row["dob"]))

The date you receive 01-01-1970 its not a random date but its actually the first date from unix system

answered Dec 8, 2016 at 18:07

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

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

9 Comments

Thomas Smyth Over a year ago

This has the intended effect, but adds an extra "-", like this: Date of Birth: 30-11--0001. Any suggestions?

Fabio Over a year ago

What do you mean? You can add whatever you need in date function like two minus symbols

Thomas Smyth Over a year ago

It changes the date to dd-mm-YYYY format, but adds an extra "-" for some reason, like 30-11--0001.

Fabio Over a year ago

How does it look row['dob'] if you print before pass to date function?

Thomas Smyth Over a year ago

strtotime($row["dob"]) outputs -62169984000. $row["dob"] outputs 0000-00-00

|

Mr. Engineer · Accepted Answer · 2016-12-08 18:07:06Z

1

You need to use :

date('d-m-Y', strtotime($row["dob"]))

strtotime

answered Dec 8, 2016 at 18:07

Mr. Engineer

3,5254 gold badges20 silver badges34 bronze badges

Comments

Barkati.med · Accepted Answer · 2016-12-08 18:20:10Z

0

You can use this this code to format your date

(new \DateTime($row["dob"]))->format('d-m-Y');

answered Dec 8, 2016 at 18:20

Barkati.med

6305 silver badges11 bronze badges

Collectives™ on Stack Overflow

PHP / SQL display dates in format

3 Answers 3

9 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

9 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related