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 --- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php