PHP parse a string to make a date?

Question

Ok i have this in my mysql database in a datetime field

2011-12-30 14:07:46

i need using php to use this format

December 30, 2011, 2:07 pm

so i used this

date("F j, Y, g:i a", $system['date_added']);

but the outcome was this error

A non well formed numeric value encountered in quote.php on line 56

and this outcome

December 31, 1969, 4:33 pm

I know there is

print_r(date_parse($system['date_added']));

but i get an array....any ideas on an easy way to address this

SO is so popular that people dont go to forum, irc, list or even google — Shiplu Mokaddim
– Shiplu Mokaddim, Commented Dec 30, 2011 at 20:23

Headshota · Accepted Answer · 2011-12-30 20:14:59Z

3

The second param of the date should be the unix timestamp, which you can get using strtotime which gets string representation of a date and converts it to unix timestamp:

date("F j, Y, g:i a", strtotime($system['date_added']));

answered Dec 30, 2011 at 20:14

Headshota

21.4k13 gold badges63 silver badges82 bronze badges

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

2 Comments

oezi Over a year ago

correct answer, but how should anyone learn from this without even a tiny piece of explanation?

Dion Over a year ago

strtotime() converts an english formatted time string to an UNIX-Timestamp. That you can convert to any time format you want.

gen_Eric · Accepted Answer · 2011-12-30 20:15:24Z

3

You can use strtotime.

date("F j, Y, g:i a", strtotime($system['date_added']));

answered Dec 30, 2011 at 20:15

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

Comments

kba · Accepted Answer · 2011-12-30 20:16:41Z

2

The date()'s second argument is a UNIX timestamp, you're giving it 2011-12-30 14:07:46 which is not.

There are two ways to handle this. Either one will work.

Pull out the date as a UNIX timestamp.

SELECT UNIX_TIMESTAMP(`field`) FROM ...

Parse the date using strtotime().

$timestamp = strtotime($system['date_added']);
date("F j, Y, g:i a", $timestamp);

answered Dec 30, 2011 at 20:16

kba

19.5k6 gold badges65 silver badges90 bronze badges

Comments

Teson · Accepted Answer · 2011-12-30 20:16:04Z

0

wrap your db-date with strtotime()

http://php.net/manual/en/function.strtotime.php

answered Dec 30, 2011 at 20:16

Teson

6,7469 gold badges50 silver badges70 bronze badges

Collectives™ on Stack Overflow

PHP parse a string to make a date?

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related