Sorry to tell you that but that's why i ask here this question, because i get everytime 01.01.1970.. RTFM i did ! On 11/11/06, M.Sokolewicz <tularis@xxxxxxx> wrote:
well, I could say RTFM, but I'll help you this time with a few links: 1. date() http://www.php.net/manual/en/function.date.php 2. strtotime() http://www.php.net/manual/en/function.strtotime.php - tul P.S. RTFM! Alain Roger wrote: > 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 R. ------------------------------------ Windows XP SP2 PostgreSQL 8.1.4 Apache 2.0.58 PHP 5
