Re: convert postgres date to PHP

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@php.net> 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