what is equalent of dateadd function in IBM Informix

system · February 2, 2011, 10:26pm

I have a BO report pulling out of IBM Informix database.Does anyone know an equalent of dateadd function in Informix database.
I tried using the below but doesn’t work:-
SELECT "2008-04-14 10:00"DATETIME YEAR TO MINUTE - 30 UNITS MINUTE FROM systables WHERE tabid=99

Thanks,
–H

hourigan (BOB member since 2007-04-06)

system · February 3, 2011, 7:22pm

Did you try… datetime(hh,17,CALENDAR_DATE)

katullus (BOB member since 2009-08-21)