'DB2 to Postgres Function

I need to change function of db2 to posgtgre



Solution 1:[1]

You don't need a FROM clause in Postgres to begin with.

The function seems to return the number of days since 0001-01-01 which can be express in Postgres as:

select current_date - date '0001-01-01';

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 a_horse_with_no_name