format mysql timestamp using php

Question

i have column named postDate defined as timestamp. when i print it directly:

echo $result['postDate'];  

i do get that what is stored(eg. 2011-03-16 16:48:24) on the other hand when i print it through date function:

echo date('F/j/Y',$result['postDate']) 

i get December/31/1969

what am i doing wrong?

many thanks

Answer 1

try this.

date('F/j/Y',strtotime($result['postDate'])); 

as timestamp is required, not formatted date as second parameter. or you can also try

SELECT UNIX_TIMESTAMP(postDate) as postDateInt from myTable 

instead of SELECT postDate from myTable and then have this in your code.

date('F/j/Y',$result['postDateInt']); 

Answer 2

The PHP date function looks for an int time() as the 2nd param. Try using strtotime()

echo date('F/j/Y', strtotime($result['postDate']) );