Re: months_between function

Eric,
months_between only works on Oracle dates. Either use the to_date function, or use Oracle default date format:

select months_between('01-FEB-96','15-NOV-96') from dual;

• Gene Plagge

Eric St-pierre wrote in message <01be0e6d$a11d7900$7316320a_at_w00ai407>...
>I forgot... We use oracle 7.3.
>--
>Eric St-Pierre
>CPD5 Associate
>ericst_at_mediom.qc.ca
>
>Eric St-pierre <ericst_at_mediom.qc.ca> a écrit dans l'article
><01be0e6d$6dc4f100$7316320a_at_w00ai407>...
>> Does anybody knows where that query does not work :
>>
>> select months_between('1996-02-01','1996-11-15')
>> from dual;
>>
>> This Query return NULL. Is there a problem with the months_between
>function
>> ?
>>
>> Thanks.
>>
>> --
>> Eric St-Pierre
>> CPD5 Associate
>> ericst_at_mediom.qc.ca
>>
Received on Fri Nov 13 1998 - 10:17:32 CST