Forum OpenACS Q&A: Response to date_add, returns "wrong" dates

Collapse
Posted by MaineBob OConnor on

It was at my end, I did a:
drop function date_add (date, integer, text);

And again pasted the whole function into psql and it works as advertized... The only thing i can think of is the first time I loaded the function:
LANGUAGE 'plpgsql';
as a separate line... ??? Oh well...

AND I have written to Mark Steele (msteele@inet-interactif.com) the original author, (Thanks Roberto) and suggested that the function be improved to pass forward the hours rather then make it midnight when using this function to update fields:
update jtest set insert_date=date_add insert_date,1,'DAYS')...;

-Bob