convert postgres date to PHP
| From: | Alain Roger | Date: | Sat, 11 Nov 2006 15:59:19 +0000 |
| Subject: | convert postgres date to PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-244495@lists.php.net to get a copy of this message | ||
Hi,
in my database PosgreSQL i have stored some date in the following format :
YYYY-MM-DD HH:MM:SS
this is a real TimeStamp without time zone field format.
Under PHP i would like to display this field as text with the following
format "DD.MM.YYYY"
How can i do that ?
i was thinking to do :
$date_from_pgsql;
echo date("d.m.Y",$date_from_pgsql);
but in this case it displays 01.01.1970 :-(
any idea ?
thanks.
--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.1.4
Apache 2.0.58
PHP 5