Forum OpenACS Q&A: Response to sysdate() problem with OpenAcs 4

Collapse
Posted by Jonathan Ellis on
The pg equivalent of sysdate is now. The alias for 3.2.x is
-- sysdate hack to make things look somewhat alike
create function sysdate() returns datetime as '
begin
        return ''now'';
end;' language 'plpgsql';