formatting datetime

[[deleted]]

I'm using the below code to format my datetime timestamp.

date("h:i A T M d, Y",$DisplayNews_row->Date)

The datetime is 2002-06-06 21:07:11, but the above code returns

07:33 PM Eastern Standard Time Dec 31, 1969

I'm using Windows XP, IIS 5 and PHP 4.2.2.

What am I doing wrong?

[rIkLuNd]

Try this:

date('Y-m-d H:i:s');

[keith73]

I don't see anything wrong with your formatting in the date statement. The problem must be that it is returning 0 for the time. I've run into this before myself.

Verify that $DisplayNews_row->Date is holding a valid timestamp, if it returns 0, check the DB itself. What DB are you using?

I used your code (using strtotime to convert the date into timestamp) and I got the proper results

print date("h:i A T M d, Y",strtotime("2002-06-06 21:07:11"));

//outputs 09:07 PM Eastern Standard Time Jun 06, 2002

• Keith

[[deleted]]

I checked by echoing

$DisplayNews_row->Date and a valid datetime was printed.

2002-06-06 21:07:11

[keith73]

try this

date("h:i A T M d, Y",strtotime($DisplayNews_row->Date))

date requires the optional second argument to be a timestamp, not a string.

• Keith

[[deleted]]

That worked!

Thanks.