RE: [PHP] Timestamps and strftime
| From: | Mayer, Jonathan | 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