Max and min date value in Informix IDS 7.31

Hi,

does anybody know if it is possible to get the minimum or maximum date
value within Informix IDS 7.31 within an stored procedure?

I mean something like this:

CREATE PROCEDURE PROCNAME()

LET date_variable = MINVALUE();

......

END PROCEDURE;

where date_variable is a variable of type DATE YEAR TO DAY.


I have searched within documentation and I don't find anything. If the
minimum date were 31-12-1899 for example I would like to be able set
this value automatically without having to write it.

Thank you all.

Alan

.

Relevant Pages