> Bottom line: update to 7.4. You could hack around it in 7.3 by
> explicitly promoting the date to timestamp without time zone
> (or better, make a function to_char(date) to do it for you)
> but I think your time would be better spent on an update.
Since i can't update to 7.4 (for internal reasons),
I created the following function to_char(date,text) :
CREATE function to_char(date,text) returns text as ' select
to_char($1::timestamp,$2);' language sql;
It worked well
thx
Najib.