months_between & new_time

In sql 2000 months_between & new_time do these functions work?I think you may be looking for the function called datediff. See BOL for
details
--
Ray Higdon MCSE, MCDBA, CCNA
--
"trollins" <anonymous@.discussions.microsoft.com> wrote in message
news:247B8AC4-CBA6-4F23-8EEE-BE5713CB574D@.microsoft.com...
> In sql 2000 months_between & new_time do these functions work?|||Hi,
Months_between : Datediff (datepart,startdate,enddate)
--Datepart can be year, month, Quarter, day
...)
new_time : getdate()
Thanks
Hari
MCDBA
"trollins" <anonymous@.discussions.microsoft.com> wrote in message
news:247B8AC4-CBA6-4F23-8EEE-BE5713CB574D@.microsoft.com...
> In sql 2000 months_between & new_time do these functions work?