RE: [PHP] Timestamps and strftime

From: Date: Thu, 04 Jun 2009 06:36:44 +0000
Subject: RE: [PHP] Timestamps and strftime
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-293594@lists.php.net to get a copy of this message
Off the top of my head, would strtotime work? ie strftime("%j",strtotime($row['UpdateDate'])) -----Original Message----- From: John Comerford [mailto:johnc@optionsystems.com.au] Sent: 04 June 2009 07:10 To: php-general@lists.php.net Subject: [PHP] 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

« previous php.general (#293594) next »