Formatting a date coming from a database table

[lalnfl]

I am have troubles displaying a date. I got the information from the database. Then I used the date() function.

 

This is how it looks:

 

$date = date('M j,Y' , $post_date);

 

the $post_date is from the database query

 

I defined it as $post_date = $row3['post_time'];

 

In the database I am using datetime for the post_time field

 

If you understand the mess I just said, do you know what I am doing wrong? And please show examples.

 

I did echo it, but when I did, it display Dec 31, 1969. The day should be Jul 9, 2010

[myrddinwylt]

Hello,

 

The datetime field stores the date and time as a string in the format "Y-m-d h:i:s A". As this is a string format, you can not format the date string without converting it back into a timestamp variable type.

 

Try the following

$post_date = strtotime($row3['post_time']);

[.josh]

...or just format it in your query so the result returned from the query is already formatted...

[lalnfl]

myrddinwylt  you are a life saver or at least a php saver. THANKS A BUNCH!!!