[PHP] convert postgres date to PHP

[Alain Roger]

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