Re: convert postgres date to PHP

# raf.news@gmail.com / 2006-11-11 16:59:19 +0100: > 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 ? http://www.postgresql.org/docs/8.1/static/functions-formatting.html Pay attention to the to_char() function. -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991