Timestamps and recalling them

[DeepBlerg]

Hi,

In a mySQL database I have a field called date in a table set as type timestamp(14). A PHP page adds values to the db including a hidden date('Y-m-d H:i:s'); into the field in the db.

On another page I recall these values to display them and everything works fine except the date which is recalled like this: date("l, jS F, Y-h:i.sA",$row[1]) on each record is the same and is some weird value like January 19 1970.

Any ideas how I can fix this?

Thanks.

 

[sonnysavage]

Try passing it through strtotime() first, to convert it to a Unix time stamp.

 

[KarveR]

Or use the mysql date_format($fieldname,"%d %M %Y) function in your select.
SELECT field1,field2,date_format($yourfield,"%d %M %Y&quot,otherstuff FROM table WHERE etc;

http://www.mysql.com/doc/D/a/Date_and_time_functions.html

***************************************
Party on, dudes!