Re: [PHP] convert postgres date to PHP

2006-11-12 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2006-11-11 16:59:19 +0100: Hi, in my database PosgreSQL i have stored some date in the following format : -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

[PHP] convert postgres date to PHP

2006-11-11 Thread Alain Roger
Hi, in my database PosgreSQL i have stored some date in the following format : -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. How can i do that ? i was thinking to do :

Re: [PHP] convert postgres date to PHP

2006-11-11 Thread Børge Holen
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 : -MM-DD HH:MM:SS this is a real TimeStamp

Re: [PHP] convert postgres date to PHP

2006-11-11 Thread Børge Holen
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 : -MM-DD HH:MM:SS this is a real TimeStamp without time zone field format. Under PHP i would like to