Calculate months Diff between dates in informix:Reg

spandan_kiran · #1 (**permalink**) 10-01-04, 02:08

Hi!
All of You, Please Help me I am Maintaing Informix Serve(9.21)Please I want to calculate months between two Dates.How can i Calculate Months by diffrentiate two dates.In Orcale we have function "addmonths", i think in Informix don't have like that function. Please Help Me.

Advanced Thanks...

gurey · #2 (**permalink**) 10-01-04, 10:36

Hi,

I think that if data type is DATE, then use MONTH() function.
If data type is DATETIME, next to calculate apply EXTEND() function.

Gustavo.

spandan_kiran · #3 (**permalink**) 10-03-04, 04:50

Thank You very much for Replying "Gustavo",

Please Give me one example using month function, Using month function Month(some date) will give that month how we can diffretiate that..
My problem is, i had two years of applications(in that i have to fetch below three months pending, more than three months pending, more than six month pending) How can do that please help me....show one example..Data type is DATE

Internet Services

Web Development

Digital Marketing

Consumer Tech