Re: convert postgres date to PHP
| From: | Børge Holen | Date: | Sat, 11 Nov 2006 16:54:43 +0000 |
| Subject: | Re: convert postgres date to PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-244500@lists.php.net to get a copy of this message | ||
And while on it...
Explode could do the trick to.
On Saturday 11 November 2006 16:59, 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.
--
---
Børge
Kennel Arivene
http://www.arivene.net
---