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