[SOLVED] Invalid date/time being displayed

[rkstevens]

I have the following code:

$formatdate = "l F n, Y g:ia";
echo (date($formatdate,$concertinfo[EventDate]));

$concertinfo[EventDate] is a timestamp stored in a database with the value of: 2008-08-20 20:00:00

but when I display it using the above date function, I get: Wednesday December 12, 1969 7:33pm

 

What do I have wrong?

 

[ILYAS415]

[code]try changing
[code]$formatdate = "l F n, Y g:ia";

to

[/code]$formatdate = "Y F n, l g:ia";[/code]

[rkstevens]

[code]try changing
[code]$formatdate = "l F n, Y g:ia";

to

[/code]$formatdate = "Y F n, l g:ia";[/code]

Displays: 1969 December 12, Wednesday 7:33pm

 

[rkstevens]

I know I have one mistake, that the lower-case 'n' should be a lower-case 'j', but it still displays wrong:

 

$formatdate = "l F j, Y g:ia";

[PFMaBiSmAd]

Ummm. The php date() function takes a Unix Timestamp as the second parameter. You are giving it a yyyy-mm-dd hh:mm:ss value.

 

To format a DATETIME from your database, use the mysql DATE_FORMAT() function directly in the query - http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

 

[rkstevens]

I had just thought of that, and replaced the $variable with strtotime($variable) and it worked.

 

Thank you.