timestamp display on the page 1

[Keendev]

hi,

need a little help here in displaying record coming from database.

I have dateUpdated column field name (timestamp) on my table, and I output it on my php page using the date function.

 //put it in a var
$updated = $row[dateUpdated] ;
$updated = date("Y-m-d",$updated); 

// display
echo $updated ;

when i view it .. all of the date value displays "1970-01-01"

thanks in advance

 

[Vragabond]

AFAIK the timestamp (not unix timestamp) in a database is just a string and date() function needs an actual date to format it. You could run $updated through [tt]strtotime()[/tt], which would convert it to what you need.

However, if you're getting this date from mysql database, it is much quicker and better if you format it in the actual database, while you're retrieving it. You would then use DATE_FORMAT to format your timestamp appropriately.