Results 1 to 3 of 3

Thread: difference in dates

  1. 09-27-2004, 08:53 PM #1
    rav
    rav is offline Registered User
    Join Date
    Sep 2004
    Posts
    2

    difference in dates

    I'm an Oracle newbie...

    I have two dates on table. I need to find the number of months between the two dates.

    Thanks.
    Reply With Quote Reply With Quote
  2. 09-28-2004, 01:26 AM #2
    vinitasinha
    vinitasinha is offline Registered User
    Join Date
    Sep 2004
    Posts
    7
    Hi,
    You could use the built in oracle function months_between, which returns the number of months between 2 dates.

    Eg:
    select months_between(end_dt, start_dt)
    from tbl

    -Vinita
    Reply With Quote Reply With Quote
  3. 09-28-2004, 06:30 PM #3
    rav
    rav is offline Registered User
    Join Date
    Sep 2004
    Posts
    2
    Thanks,
    I tried it and got the results I was looking for.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules