Thanks Jonathan,
Thats exactly what I needed.
I appreciate the help,
JC
Mayer, Jonathan wrote:
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
--
Option Systems Pty. Ltd.
53 Waverley Road, Malvern East, VIC 3145
PO Box 7, Caulfield East, VIC 3145
Phone: 03 9571 0100 Fax: 03 9571 0500
The information in this e-mail is confidential and is intended solely for the addressee.
Any views or opinions presented are solely those of the author
and do not necessarily represent those of Option Systems Pty.Ltd.
If you are not the intended recipient, please delete this message and
contact the sender.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
