convert postgres date to PHP

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

 



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

[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