sysdate assumes year 1900 in months

From: Joe Worthington <josephwor_at_hotmail.com>
Date: Fri, 4 Feb 2000 10:45:32 -0500
Message-ID: <87es7q$k1v$1@nntp9.atl.mindspring.net>

I am comparing sysdate (now 2000) to a date field. Oracle is assuming that sysdate is 1900. See code below.

select
ketsTimeAcctSalesman,
sysdate System_Date,
ROUND(MONTHS_BETWEEN(Sysdate, ketsTimeAcctSalesman),0) Time_Assigned_to_Salesman
FROM KETS_ACCT_PROFILE
where (ROUND(MONTHS_BETWEEN(Sysdate, ketsTimeAcctSalesman),0) < 0);

This code produces the following.

KETSTIMEACCTSALESMAN SYSTEM_DATE TIME_ASSIG

------------------------------ -------------------- ----------
15-SEP-99                      04-FEB-00                 -1195
05-OCT-99                      04-FEB-00                 -1196
03-FEB-99                      04-FEB-00                 -1188
01-FEB-96                      04-FEB-00                 -1152
02-APR-98                      04-FEB-00                 -1178
01-JAN-99                      04-FEB-00                 -1187
01-JAN-99                      04-FEB-00                 -1187

Any Ideas ? Received on Fri Feb 04 2000 - 09:45:32 CST

sysdate assumes year 1900 in months_Between calculations