Oracle's months_between -function

From: eh <timo.talja.email_at_gmail.com>
Date: Mon, 1 Feb 2010 05:39:05 -0800 (PST)
Message-ID: <e8d5d9c4-89f0-45c6-82d4-86402b47c2f5_at_y12g2000yqh.googlegroups.com>

Hi,
is there an obviuos explanation to this case; months_between -function seems to act a little weird with time given:

---

select months_between(to_date('02.02.2010','dd.mm.yyyy'),to_date ('01.02.2010', 'dd.mm.yyyy'))
from dual
---> 0.0322

---

... and then we add times to the mask

---

select months_between(to_date('02.02.2010 00:00:01','dd.mm.yyyy hh24:mi:ss'),to_date('01.02.2010 23:59:59', 'dd.mm.yyyy hh24:mi:ss')) from dual
---> 7,467

---

How about that ???
is it so simple that do not use time-format with monts_between .??? BR,
timo Received on Mon Feb 01 2010 - 07:39:05 CST