Off the top of my head, would strtotime work? ie strftime("%j",strtotime($row['UpdateDate'])) -----Original Message----- From: John Comerford [mailto:johnc@xxxxxxxxxxxxxxxxxxxx] Sent: 04 June 2009 07:10 To: php-general@xxxxxxxxxxxxx Subject: Timestamps and strftime Hi, I am having a problem trying to use a date that I take from a MySQL database. The field is defined as a timestamp in the database. I extract it using PDO and I am trying to use the value with strftime as follows: foreach ($stmt->fetchall(PDO::FETCH_ASSOC) as $row) { echo strftime("%j",$row['UpdateDate']); } but it returns the following error: PHP Notice: A non well formed numeric value encountered... I understand that this is because strftime is expecting a numeric value and that ,$row['UpdateDate'] is a character but I am not sure how to resolve the issue. Any help would be apprecaited. TIA, JC -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php