Re: convert postgres date to PHP

You get that because your input is not a unix timestamp, it's a RFC 3339 formatted date-/timestamp. You first need to convert it (using ie. strtotime, or explode() and feeding it to mktime()) to a unix timestamp before you can feed the unix timestamp to the date() function. Unix timestamps are integers. When feeding it into date() the STRING (because '2006-11-11 01:02:03' is a STRING) will be converted to an integer (value of 0) and interpreted as being a "valid" unix timestamp (namely, 0). Unix Timestamp = 0 is January 1st, 1970. The start of the UNIX epoch. - tul Alain Roger wrote:

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.