Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    5

    Unanswered: Calculate months Diff between dates in informix:Reg

    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...

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    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.

  3. #3
    Join Date
    Aug 2004
    Posts
    5

    How we can calculate Using month() function:Reg

    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
    Last edited by spandan_kiran; 10-03-04 at 05:52.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •