PHP date time and mysql [duplicate]

Question

Possible Duplicate:
Change date format (in DB or output) to dd/mm/yyyy - PHP MySQL
PHP - Convert to date format dd/mm/yyyy

mysql saves my date and times like this...

 2011-08-31 08:48:40

And when I echo them from the database this is how they appear, how can I get them to a universal format like m/d/y...

Or does it not matter if the mysql row is not a DATE_TIME and just VARCHAR and insert it into the database how I want it??

Thanks...

erm... what you have there is an universal format. m/d/y is a locale format... — Alin P.
– Alin P., Commented Sep 1, 2011 at 6:15
Thank you... put it as an answer and I will mark it as correct :) — carlgcode
– carlgcode, Commented Sep 1, 2011 at 6:18

Alin P. · Accepted Answer · 2011-09-01 06:17:47Z

Do it in PHP:

date("m/d/Y", strtotime('2011-08-31 08:48:40'));

Or do it in MySQL:

SELECT DATE_FORMAT('2011-08-31 08:48:40','%m/%d/%Y')

Of course you won't use hardcoded values in your code. You'll use the column name for MySQL or the retrieved column value, that's probably an element in an array, in PHP.

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

This post is previously answered:

Convert to date format dd/mm/yyyy

Regards

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Sep 1, 2011 at 6:16

GoRoS

5,4052 gold badges46 silver badges67 bronze badges

Collectives™ on Stack Overflow

PHP date time and mysql [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related