Dunno 'bout posgresql, but mysql can handle that situation quite easily with
DATE_FORMAT witch is what I use.
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
---
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
