HELP.... DATEDIFF function for INFORMIX. THX.

[Juan Alfredo]

I need use the function datediff for informix. Please, one example.

THX.

[gingishan]

"Juan Alfredo" <jasantos@asnc.sas.junta-andalucia.es> wrote:
>
>I need use the function datediff for informix. Please, one example.
>
>THX.



DEFINE DATE1 DATE;
DEFINE DATE2 DATE;

LET DATE1 = TODAY;
--MINUS 1 MONTH
LET DATE2 = DATE1 - INTERVAL(1) MONTH TO MONTH;
--MINUS 1 YEAR
LET DATE2 = DATE1 - INTERVAL(1) YEAR TO YEAR;