That's a mysql timestamp, if you want to manipulate dates in PHP you'll need to use unix timestamps.
You have a couple of options, select unix_timestamp(myFld) as myFld from myTbl Then just add 60*60*24*7 to it. Or, parse it with: function convert_timestamp ($timestamp) { $timestring = substr($timestamp,0,8)." ". substr($timestamp,8,2).":". substr($timestamp,10,2).":". substr($timestamp,12,2); return strtotime($timestring); } "Diff Fannehh" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > I have this date in timestamp format: > > $a= 20040810114155; > > I want to add 7 days to this date. How can i do that? > > Thanks > > > > ---- > > Home, no matter how far... > http://www.home.ro -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php