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 > f

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 lik

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 TimeSta

[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 : $da