PHP date format question

Question

I'm trying to format some dates in PHP (i'm a Coldfusion programmer, so the syntax is similar, but i'm stuck!).

The dates are formatting perfectly into the display I want. However, they all return 1st Jan 1970.

Can anyone shed any light on this?

For background, I am pulling a date from a datetime column in mySQL. The raw date i'm trying to format is....

2010-04-03 00:00:00

Here is the line of code i'm using....

$xml_output .= "\t\t<eventdate>" . date("l jS F", $row['event_date']) . "</eventdate>\n";

I want it to display as: Saturday 3rd April

Any help would be appreciated!

Simon

Pekka · Accepted Answer · 2010-02-13 16:43:27Z

6

The second parameter to date() needs to be a UNIX timestamp.

Convert your date string it into a timestamp first using strtotime():

$timestamp = strtotime($row["event_date"]);
echo date("l jS F", $timestamp); // Saturday 3rd April

Manual pages:

edited Feb 13, 2010 at 16:43

answered Feb 13, 2010 at 16:31

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

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

1 Comment

Decent Dabbler Over a year ago

You forgot to pass $timestamp as an argument to date()

Pascal MARTIN · Accepted Answer · 2010-02-13 16:33:09Z

2

The date function works with an UNIX timestamp (i.e. a number of seconds since January 1, 1970), and not a date passed as a string.

This means you have to first convert your date to a timestamp, using strtotime, for instance :

$timestamp = strtotime('2010-04-03 00:00:00');

And, then, you can use the date function on this timestamp :

echo date('l jS F', $timestamp);

Which gets you the output you wanted :

Saturday 3rd April

answered Feb 13, 2010 at 16:33

Pascal MARTIN

402k82 gold badges665 silver badges666 bronze badges

Comments

Decent Dabbler · Accepted Answer · 2010-02-13 17:05:57Z

1

Alternatively, you could let MySQL format the date for you on retrieval (makes for cleaner code in building your XML):

SELECT
  event_date,
  DATE_FORMAT( event_date, '%W %D %M' ) AS event_date_formatted
FROM
  ...

Then in PHP:

$xml_output .= "\t\t<eventdate>" . $row['event_date_formatted'] . "</eventdate>\n";

Also:
MySQL date formatting functions are a bit more flexible, as they don't depend on unix timestamps that much (if you use DATETIME fields, that is). Admittedly a bit unlikely perhaps; but if your event_date exceeds the unsigned 32 bit integer timestamp boundaries, your pretty much screwed with php's date function. Try formatting a date before January 1st 1970, or after January 19th 2038, and you will see what I mean.

edited Feb 13, 2010 at 17:05

answered Feb 13, 2010 at 16:41

Decent Dabbler

22.8k11 gold badges77 silver badges107 bronze badges

1 Comment

Simon Hume Over a year ago

awesome, that'll probably be a lot faster for the result return. i'll give that a go! the fix above for the unix timestamps has fixed the issue anyway. But I'd sooner have the sexier dates straight out of mySQL :)

Matteo Riva · Accepted Answer · 2010-02-13 16:32:02Z

0

Use the strftime() function to convert the datetime you get from a database in a unix timestamp suitable for date():

date("l jS F", strtotime($row['event_date']))

answered Feb 13, 2010 at 16:32

Matteo Riva

25.1k13 gold badges75 silver badges105 bronze badges

Comments

Gal · Accepted Answer · 2010-02-13 16:32:18Z

0

PHP date function expects to receive a unix timestamp.

Change the format of the date you pull from the db to unix timestamp.

answered Feb 13, 2010 at 16:32

Gal

23.7k32 gold badges101 silver badges118 bronze badges

Collectives™ on Stack Overflow

PHP date format question

5 Answers 5

1 Comment

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related