Greatest Function in Netezza

Question

Am trying to find the equivalent statement to below in Netezza

greatest(table1.column1, table2.column2, table3.column3)

also

least(table1.column1, table2.column2, table3.column3)

all the columns are dates

Any help is appreciated.

Answer 1

In newer versions of Netezza, this will also work:

max(table1.column1, table2.column2, table3.column3)
min(table1.column1, table2.column2, table3.column3)