Timesheet and Absence shows query errors

**
. I am using psql 8.4.11. What can I do to fix the following issue.

the timesheet tab shows the following error .**

Database operation "0or1row" failed (exception ERROR, "ERROR: function to_date(integer, unknown) does not exist LINE 1: select to_char(to_date(2456141, 'J'), 'YYYY-MM-DD');

^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. ") ERROR: function to_date(integer, unknown) does not exist LINE 1: select to_char(to_date(2456141, 'J'), 'YYYY-MM-DD');

^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

**The absences tab shows the following error. **

Database operation "select" failed (exception ERROR, "ERROR: function upper(timestamp with time zone) does not exist LINE 21: order by owner_name, upper(start_date);

^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. ") ERROR: function upper(timestamp with time zone) does not exist LINE 21: order by owner_name, upper(start_date);

^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Please please some one help me on this. From past 2 weeks i am stuck with this.

Hi,

This error has been fixed in V4.0 (please check this forum on how to obtain the latest version
from CVS).
The error does not appear in PG 8.2, which has more tolerant definitions of built-in procedures.

So you can either upgrade the ]po[ or downgrade your database…
I assume you are not using the VMware, but you have installed ]po[ manually somehow, is that right?

Cheers,
Frank