RE: Timestamps and strftime

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux