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
ahum 9.3...... anyways...
export DBDATE=dmy4-
i would say min date is
01-01-0001
max date is
31-12-9999
try
select date("31-12-9999") :: int from systables
where tabname = 'systables';
select date(2958463+1 ) from systables
where tabname = 'systables';
select date(2958464+1 ) from systables
where tabname = 'systables';
1210: Date could not be converted to month/day/year formast
which makes sense......
Superboer.
Massoroto schreef:
> 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